Error Establishing a Database Connection

  • Resolved fawzi007

    (@fawzi007)


    8 years, 12 months ago

    I Have migrated my website to a new host using the duplicator plugin but after migrating it, when I tried to login, they say: ‘Error Establishing a Database Connection’. The DB name,user, password and host in the wp-config.php file are all correct. I tried to repair the database using this line of code : ‘define(‘WP_ALLOW_REPAIR’, true);’, but after the repair is finished they say :

    ‘Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.

    wp_tkn5zfvcvr_users: Table ‘blushake_youraidem.wp_tkn5zfvcvr_users’ doesn’t exist
    wp_tkn5zfvcvr_usermeta: Table ‘blushake_youraidem.wp_tkn5zfvcvr_usermeta’ doesn’t exist
    wp_tkn5zfvcvr_links: Table ‘blushake_youraidem.wp_tkn5zfvcvr_links’ doesn’t exist
    wp_tkn5zfvcvr_options: Table ‘blushake_youraidem.wp_tkn5zfvcvr_options’ doesn’t exist
    ‘
    Please help me ASAP! What should I do ?

Viewing 5 replies - 1 through 5 (of 5 total)
  • catacaustic

    (@catacaustic)

    8 years, 12 months ago

    If you’re getting that error then at least one of the database connection settings in your wp_config.php file are not correct. If you’re 100% sure that the username, password and database name are correct, then the host may need to be changed. Some hosts need ‘localhost’ where others may need ‘127.0.0.1’ and others may need an external MySQL server URL.

    One thing to remember is that unless you have set them up exactly the same way you will have a different database name, username and password on the new server (a lot of peope get tricked by that one).

    Thread Starter fawzi007

    (@fawzi007)

    8 years, 12 months ago

    @catacaustic Hello, the database is testing correctly but it isn’t working. As you can see.

    • This reply was modified 8 years, 12 months ago by fawzi007.
    catacaustic

    (@catacaustic)

    8 years, 12 months ago

    If you are 100% Sure, check the tables using phpMyAdmin or something similar. Most hosts will have that available in your websites control panel. If the error messages that you gave above are accurate, the database tables are just not there. If that’s the case you’ll need to have them restored from a backup (you do have backups, right???). If you don’t have any backups contact your hosting company and ask them to restore a working version of the site.

    Thread Starter fawzi007

    (@fawzi007)

    8 years, 12 months ago

    @catacaustic Yes I checked phpMyAdmin and the database tables are not there. I’ll try to restore them back though when I used the duplicator, they backed up the database tables. Thanks for your help!

    Thread Starter fawzi007

    (@fawzi007)

    8 years, 12 months ago

    Problem Resolved : I restored the database manually, by exporting a sql file from my old website using a plugin (because I don’t have access to the cpanel of my old website) and imported it in my new website using phpMyAdmin, because some tables were missing and it worked.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Error Establishing a Database Connection’ is closed to new replies.