Support » Fixing WordPress » Help! Mysql dump messed up!

  • I tried doing a mysql dump as I was importing posts from WP on one server /domain to another (see
    I thought everything had gone smoothly, but check this out:
    Aaarrggghh! It’s not meant to look like that, btw! Do I go through and try and correct everything single one of the errors? Or is there one biggie here?
    Any HELP would be greatly appreciated! (I’m kinda stressed because – due to the move – the site’s been down for over a week.)

Viewing 5 replies - 1 through 5 (of 5 total)
  • Sorry – that was the wrong URL. I’ve updated it now.

    Any ideas? Is there an easy way to clear the database so I can start again?

    Use phpmyadmin to “drop” the wp tables.
    Use a different prefix (the default it “wp_”) in the new blog’s wp-config.php file.

    You’ll have to forgive my ignorance here, but if I drop the tables why would I need to change the prefix?
    Wouldn’t I just have an empty database that I could start from fresh with?
    Also, I was thinking of just doing a fresh install and re-importing posts from Blogger and going from there. Could I just empty the current database and do that or is it simpler/easier/safer to just start a new db?
    This newbie thanks you in advance! 🙂

    If you drop the tables, then you don’t need to change the prefix. I meant to say that you could change the prefix, install and then drop the old tables if everything goes fine.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Help! Mysql dump messed up!’ is closed to new replies.