Support » Fixing WordPress » Restore WordPress database from backup

  • Resolved peredur

    (@peredur)


    Hi. I need to restore my site back to its previous state after a disastrous set of updates broke some things on the site. I have a db backup taken using phpmyadmin and a site backup so I should be OK. I have a question though.

    When restoring the database, should I delete all the currently existing tables first? The codex instructions imply that this is not necessary, but nearly everything else I’ve read suggests it is.

    The sql says to create the table if it doesn’t exist, but doesn’t say to drop it if it does, so I’m not sure how the import would work.

    Thanks in advance

    PAE

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Forum Moderator & Support Team Volunteer

    Drop the tables first. If you’re about to replace them, it really doesn’t matter.

    Thread Starter peredur

    (@peredur)

    Thanks, sterndata. That’s what I thought, but I was just a bit confused by the wording on the codex.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Restore WordPress database from backup’ is closed to new replies.