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?

  • 1
    Are all credentials in wp-config.php right? Don't forget from table prefix. – Alexey Jan 27 '15 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? – mebu83 Jan 27 '15 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 Jan 27 '15 at 20:41

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

| improve this answer | |
  • As you asked, Joshua :) – Alexey Jan 28 '15 at 23:24

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.

| improve this answer | |

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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.