Some tables are missing in database after a SQL migration

  • chaaampy

    (@chaaampy)


    6 years, 7 months ago

    Hi everyone,

    Unfortunately, I can’t post my WP / plugins versions and Im sorry for it.
    Let me explain myself.

    Someone contacted me because they had an issue, the famous “Error establishing a database connection”.

    The fact is they had their DB hosted on a private SQL server (OVH) and they didnt renew the paiment for it … so someone changed to wp-config with the new database access.

    So after trying to get onto the website, I tried to repair the database, and I got this message :

    "naturama_usermeta: Table 'naturamaweb.naturama_usermeta' doesn't exist
naturama_posts: Table 'naturamaweb.naturama_posts' doesn't exist
naturama_comments: Table 'naturamaweb.naturama_comments' doesn't exist
naturama_links: Table 'naturamaweb.naturama_links' doesn't exist
naturama_options: Table 'naturamaweb.naturama_options' doesn't exist
naturama_postmeta: Table 'naturamaweb.naturama_postmeta' doesn't exist
naturama_terms: Table 'naturamaweb.naturama_terms' doesn't exist
naturama_term_taxonomy: Table 'naturamaweb.naturama_term_taxonomy' doesn't exist
naturama_term_relationships: Table 'naturamaweb.naturama_term_relationships' doesn't exist
naturama_termmeta: Table 'naturamaweb.naturama_termmeta' doesn't exist
naturama_commentmeta: Table 'naturamaweb.naturama_commentmeta' doesn't exist"

    And additionally, when Im going into phpMyAdmin, I got this other message :

    Warning in ./libraries/plugin_interface.lib.php#551
 count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/display_import.lib.php#374: PMA_pluginGetOptions(
string 'Import',
array,
)
./libraries/display_import.lib.php#459: PMA_getHtmlForImportOptionsFormat(array)
./libraries/display_import.lib.php#694: PMA_getHtmlForImport(
string '5da72007901e0',
string 'database',
string 'naturamaweb',
string '',
integer 134217728,
array,
NULL,
NULL,
string '',
)
./db_import.php#44: PMA_getImportDisplay(
string 'database',
string 'naturamaweb',
string '',
integer 134217728,
)

    Im using PHP 7.2 and MYSQL v.5.6

    Any ideas to fix this ?
    Im afraid than those guys just didnt pay their bill, and just don’t have any back up of the old DB …

    Cheers,

    Tony.

Viewing 1 replies (of 1 total)
  • scsiraidguru

    (@scsiraidguru)

    6 years, 7 months ago

    I use duplicator to move the database and WordPress sites to other servers. Do you have access to the original site to migrate again? Can they restore it?

    You need to make sure both SQL servers are the same version and patch level, when moving sites. Unless you can restore the old site and migrate it properly, you will be out of luck. You should always keep an up to date backup before doing any changes to your site from content, plugins, upgrades or migrations. I don’t remove the old site till I verify the migration is complete. No database errors. No WordPress errors. LAMP logs are clean: Linux, Apache, Mariadb, and php. I verify the databases in phpMyAdmin.

Viewing 1 replies (of 1 total)

The topic ‘Some tables are missing in database after a SQL migration’ is closed to new replies.