Support » Fixing WordPress » Site Migration

  • During site migration, I found following DB error.

    CREATE TABLE wp_options ( option_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, option_name

    When I tried to fix as guided by WordPress DB repair, following message show up.

    wp_options: Table ‘hammatbi.wp_options’ doesn’t exist

    I tried it using migration plugin(UpdraftPlus Migrator).

    I also tried WordPress DB repair option, define(‘WP_ALLOW_REPAIR’, true).
    It does not help at all.

    For more info,

    Source Hosting DB is,
    MySQL, 5.7.18 – MySQL Community Server (GPL)

    -Target host DB is,
    MariaDB 10.1.20-MariaDB

    Can you please help me?

    • This topic was modified 5 years, 1 month ago by daehm.
    • This topic was modified 5 years, 1 month ago by daehm.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Do you have your original SQL export?

    If so, then drop all tables in the receiving database (retain the database) and then try the import again.

    Thread Starter daehm

    (@daehm)

    No. Because I am trying to move the site between different site url and even db name.
    And my source MySQL but target DB is InnoDB.

    An error (1) occurred: – Unknown storage engine ‘InnoDB’ – the database query being run was: CREATE TABLE wp_options ( option_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, option_name

    I will ask the backup plugin company.

    Thanks anyway.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Site Migration’ is closed to new replies.