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, 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? 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
    Jan 27, 2015 at 20:41

3 Answers 3


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

  • As you asked, Joshua :)
    – Alexey
    Jan 28, 2015 at 23:24
  • saved me with the table prefix, thank you!!
    – tiadotdev
    Jun 20, 2021 at 18:36

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

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.