Having trouble restoring site from SQL database backup

  • I was having some issues with my WordPress installation no longer allowing me to automatically upgrade my plugins after previously working fine. It claimed that the permissions were not correct, but after contacting DreamHost about it, they said that it was all in proper order, but they even changed everything to the highest permissions just in case. It still didn’t work so I decided to just start over. I backed up my SQL database and deleted everything and reinstalled, but now when I import my backup, it’s like it’s not there. None of my posts show up and it’s acting like a fresh installation. I know my posts and stuff are in this database and it’s not giving me any errors when I import it, so I’m not sure what the problem is. Can anyone help me or is this something I need to discuss with DreamHost?

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

  • Check your wp-config.php file and make sure you are connecting to the proper database. If so, then check the table prefix that is defined in the config file and make sure it’s the same as the prefix for the tables you imported in the db.

    The following video may help you understand what the wp-config.php file is looking for.

    https://educhalk.org/blog/?p=148

    Thread Starter omgitsalisa

    (@omgitsalisa)

    I didn’t watch the video because I figured it out as it was playing. The problem was in the wp-config.php file as you suggested – I had the wrong table prefix. When DreamHost installed it for me again (I do love the one-click installs) it had a different table prefix so changing that fixed it right up. Thank you so much!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Having trouble restoring site from SQL database backup’ is closed to new replies.