database - Why are no posts showing despite my apparently correct DB restoration?

I restored a backup to MySQL using the phpMyAdmin Import feature. When I browse the DB in phpMyAdmin, I see that my posts are there. But in Wordpress, I only see the default out-of-the-box welcome post. Even the WordPress admin shows no signs of the info in the database. (I checked that this is the correct database.)

How can I fix this?

I restored a backup to MySQL using the phpMyAdmin Import feature. When I browse the DB in phpMyAdmin, I see that my posts are there. But in Wordpress, I only see the default out-of-the-box welcome post. Even the WordPress admin shows no signs of the info in the database. (I checked that this is the correct database.)

How can I fix this?

• database
• wp-admin
• mysql
• backup

Share Improve this question asked Jan 25, 2015 at 7:07 Joshua FoxJoshua Fox 7322 silver badges1010 bronze badges 3

• 1 Are all credentials in wp-config.php right? Don't forget from table prefix. – Alexey Commented Jan 27, 2015 at 8:08
• From where did the backup originate from, the same server or another? Did you just restore a table or the complete database, are you sure WordPress is indeed using the same db/table? – wxT3APyGfkYJVK Commented Jan 27, 2015 at 8:23
• @Alexey Thanks that is probably it. Please add an answer so I can award you the bounty after I confirm that this really is the source of the problem – Joshua Fox Commented Jan 27, 2015 at 20:41

Add a comment  | 

3 Answers 3

Sorted by: Reset to default 5 +50

Check all credentials in wp-config.php. And don't forget about table prefix.

It sounds like you have multiple databases and that WordPress is not accessing the correct one. Check your wp-config.php file (in the base of your WordPress installation) and make sure that your database credentials, in particular DB_NAME, are set correctly.

You may also need to create/grant access to a new database user. There's about a dozen different ways of doing this, many of them are covered in the codex page on installing WordPress. Pick the one that works best for you if you have this issue.

You Should Check The Table Prefix in the wp.config file math the one in the database. For Example Most Tables starts with wp_ cross check if your new table prefix has added numbers e.g. wp143_

Thats All