Having trouble restoring site from SQL database backup (3 posts)

  1. omgitsalisa
    Posted 7 years ago #

    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?

  2. figaro
    Posted 7 years ago #

    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.


  3. omgitsalisa
    Posted 7 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Topic