SQL Backup not enough?

  • Resolved MrMyles

    (@mrmyles)


    14 years, 11 months ago

    Morning all.

    Last week my hosting server had a melt down. Not the first, and probably not the last. So I moved my site to another host. Everything went well except for the blog. I was assuming if I took a MySQL backup of the DB, and all files on the server, that was all I would need to restore it on the new server.

    Seems I was wrong.

    I installed WordPress on new server, then wiped the DB and imported the backup. Now it brings me back to the WP set up every time.

    Is it not possible to restore a blog from the SQL backup?

    This particular blog is a small members only blog. I can manually repost everything, and then ask members to sign up again, but would prefer not to.

    I also have another blog to move this weekend, which is a lot bigger and public. So I would prefer not to lose years of work.

    I know there is a WP Export (WordPress eXtended RSS) in admin, and I will use that on the next one, but is that enough?

    Thoughts/comments/questions/suggestions?

    Thanks

    Myles

Viewing 3 replies - 1 through 3 (of 3 total)
  • Samuel B

    (@samboll)

    14 years, 11 months ago

    the mysql back up is a complete site back up as opposed to the export function which only does posts, comments and authors.

    You should be able to import the db .sql file – I have done this 100’s of times.

    Without knowing more details, I will guess that your current $table_prefix in wp-config.php is different than what you had on your old set up. Look at the actual prefix in the db and make sure it is same in wp-config.php

    Thread Starter MrMyles

    (@mrmyles)

    14 years, 11 months ago

    Your right. I did change the table prefix, and had not even thought of it. See what happens when your rushed, you stumble on a pebble.

    I don’t have access to the files from this office, but will confirm this tomorrow.

    Thanks for the quick response.

    Myles

    Thread Starter MrMyles

    (@mrmyles)

    14 years, 11 months ago

    Just wanted to say thanks, that was exactly the issue. Soon as I changed the prefix to the one in the DB everything went back together.

    Moved another blog on the weekend without a hitch.

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL Backup not enough?’ is closed to new replies.

Tags