• Could someone please assist me into getting my database running again.

    I am building my website using AMMPS and came across this problem after my scratch discs were almost full
    I ran a test and these came-up.

    regards Michael

    wp_users: Table ‘wp810.wp_users’ doesn’t exist
    wp_usermeta: Table ‘wp810.wp_usermeta’ doesn’t exist
    wp_posts: Table ‘wp810.wp_posts’ doesn’t exist
    wp_comments: Table ‘wp810.wp_comments’ doesn’t exist
    wp_links: Table ‘wp810.wp_links’ doesn’t exist
    wp_options: Table ‘wp810.wp_options’ doesn’t exist
    wp_postmeta: Table ‘wp810.wp_postmeta’ doesn’t exist
    wp_terms: Table ‘wp810.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘wp810.wp_term_taxonomy’ doesn’t exist
    wp_term_relationships: Table ‘wp810.wp_term_relationships’ doesn’t exist
    wp_termmeta: Table ‘wp810.wp_termmeta’ doesn’t exist
    wp_commentmeta: Table ‘wp810.wp_commentmeta’ doesn’t exist

Viewing 8 replies - 1 through 8 (of 8 total)
  • Looks like something deleted your site’s tables. You’ll need to either restore from backup or re-install WordPress.

    Thread Starter michaelbrosnan

    (@michaelbrosnan)

    Thanks Dan
    I am struggling with this.
    I have reinstalled wordpress and dropped in all the files but no data is working. I have even bought over my back up files but nothing works.

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    Can you try with a different table prefix besides wp810? I think your mysql DB account isn’t setup correctly.

    On top of what Jan said, check your wp-config.php file and see if there is a line starting:

    $table_prefix =

    Thread Starter michaelbrosnan

    (@michaelbrosnan)

    Hi Dan
    yes there is

    $table_prefix = ‘wp_’;

    Try changing that setting from ‘wp_’ to ‘wp810’

    Thread Starter michaelbrosnan

    (@michaelbrosnan)

    Sorry It did not work>

    Moderator bcworkz

    (@bcworkz)

    wp810 is your database name, the prefix of ‘wp_’ is typically what you want.

    You say you brought in your backup files, what about your DB backup? It’s usually a .sql file, possibly named wp810.sql or whatever your old DB was named.

    If you reinstall WP using install.php, you should get a working WP installation, but there will not be any content except the Hello World! post. If you try to import the typical SQL backup over this you’ll get a bunch of table exists errors, though I believe it will otherwise work.

    You normally would want to import your SQL backup into an empty DB, all the tables should be created as part of the process. What actually happens depends on the options selected when the backup was made. Your DB apparently is currently empty, so no problem there.

    You should be able to find a SQL backup on your old server somewhere if you made one before. There’s usually a way to make a fresh backup from your hosting cPanel or equivalent if you cannot find one. Sometimes you can select where the backup goes, other times it goes on your sever somewhere, you have no choice of where. Either way, get the file onto you local computer somehow.

    Start up phpMyAdmin on your new installation, click wp810 on the DB list on the left, then go to the import tab. Browse to your backup file after clicking the Browse… button. The other defaults should be fine, click Go at the bottom and your backup data should be placed in a WP compatible set of tables. If all else is properly defined in wp-config.php, then your new installation should be partly working with your original data, but don’t try it just yet!

    There’s a good chance all of the image links and the home and site URLs on your new site with old data will be wrong. You need to do a global search and replace to change the old site URL references to the new site — UNLESS you’ve changed your original domain zone file to point to the new site or the new site is somehow already working with the original URLs.

    To do a global search and replace I recommend you use the interconnect/it script. While it’s not really that difficult to use, it is possible to horribly corrupt a DB with this tool. As long as you have that backup SQL file there’s little reason for concern, you can easily start over if you screw it up 😉

    For more information on moving sites, see Moving WordPress.

    I hope this helps, good luck!

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

The topic ‘Database connection error’ is closed to new replies.