Support » Everything else WordPress » How can you determine whether a database backup was effective?

  • eveums

    (@eveums)


    I back up my MySQL db about once a month or so according to the Codex instructions. I was wondering if there was any way for me to verify that my backups are correct and not corrupted and basically OK. Is there a simple way to do this? Or should I stop being so paranoid since I’m following the directions to a ‘t’?? 🙂 Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Mark (podz)

    (@podz)

    Support Maven

    I create a new blog and restore into that.
    That said, I have xampp on my machine so doing that takes all of 3 minutes to do. It’s the only way to be certain.

    skippy

    (@skippy)

    Member

    Once you have a known good backup, you can also use that to compare new backups.

    Assuming you’re on a UNIX-like system (GNU/Linux or Mac OSX), you can use the diff command to compare two text files, and see the differences.

    Unzip your backup files into a temporary directory, then do this:
    diff good_backup.sql new_backup.sql
    using the real file names, obviously. This will show you what’s different between the two. You should be able to visually scan for obvious anomolies.

    eveums

    (@eveums)

    Thanks for the info!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How can you determine whether a database backup was effective?’ is closed to new replies.