Title: Database connection error Last modified: September 1, 2016 --- # Database connection error * [michaelbrosnan](https://wordpress.org/support/users/michaelbrosnan/) * (@michaelbrosnan) * [9 years, 9 months ago](https://wordpress.org/support/topic/database-connection-error-47/) * 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) * [danhgilmore](https://wordpress.org/support/users/danhgilmore/) * (@danhgilmore) * [9 years, 9 months ago](https://wordpress.org/support/topic/database-connection-error-47/#post-7690684) * Looks like something deleted your site’s tables. You’ll need to either restore from backup or re-install WordPress. * Thread Starter [michaelbrosnan](https://wordpress.org/support/users/michaelbrosnan/) * (@michaelbrosnan) * [9 years, 9 months ago](https://wordpress.org/support/topic/database-connection-error-47/#post-7690697) * 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](https://wordpress.org/support/users/jdembowski/) * (@jdembowski) * Forum Moderator and Brute Squad * [9 years, 9 months ago](https://wordpress.org/support/topic/database-connection-error-47/#post-7690707) * Can you try with a different table prefix besides `wp810`? I think your mysql DB account isn’t setup correctly. * [danhgilmore](https://wordpress.org/support/users/danhgilmore/) * (@danhgilmore) * [9 years, 9 months ago](https://wordpress.org/support/topic/database-connection-error-47/#post-7690715) * 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](https://wordpress.org/support/users/michaelbrosnan/) * (@michaelbrosnan) * [9 years, 9 months ago](https://wordpress.org/support/topic/database-connection-error-47/#post-7690721) * Hi Dan yes there is * $table_prefix = ‘wp_’; * [danhgilmore](https://wordpress.org/support/users/danhgilmore/) * (@danhgilmore) * [9 years, 9 months ago](https://wordpress.org/support/topic/database-connection-error-47/#post-7690723) * Try changing that setting from ‘wp_’ to ‘wp810’ * Thread Starter [michaelbrosnan](https://wordpress.org/support/users/michaelbrosnan/) * (@michaelbrosnan) * [9 years, 9 months ago](https://wordpress.org/support/topic/database-connection-error-47/#post-7690725) * Sorry It did not work> * Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/) * (@bcworkz) * [9 years, 9 months ago](https://wordpress.org/support/topic/database-connection-error-47/#post-7690761) * 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](https://interconnectit.com/products/search-and-replace-for-wordpress-databases/). 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](http://codex.wordpress.org/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. ## Tags * [Database Error](https://wordpress.org/support/topic-tag/database-error/) * [php](https://wordpress.org/support/topic-tag/php/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 8 replies * 4 participants * Last reply from: [bcworkz](https://wordpress.org/support/users/bcworkz/) * Last activity: [9 years, 9 months ago](https://wordpress.org/support/topic/database-connection-error-47/#post-7690761) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics