Blog backup?

October 31st, 2008 by jason Leave a reply »

Just in time for Halloween, a Scary WordPress Moments! blog article has been published.

I back up my WordPress database (MySQL) daily using a Windows scheduled task.   A script (built by the MySQL Administrator) is executed which dumps the database to a file (hot backup).  The database dump is then backed up to tape nightly.  I believe the backup method is solid and I’m also thinking ease of restoring (the whole database) is easy.  Restoring individual tables or rows however – probably a nightmare I don’t want to get involved with.

There exists another backup method in plugin form located here.  Since I host my own blog, I don’t really have a need for the “Save to server” versus “Save to my computer” options.  I certainly don’t need to email the backup to myself.  I’ve already instituted a backup method that should have me covered.  It’s automated with script and scheduling so to me that’s a huge benefit.  Work smarter, not harder right?

I’m new to both blogging and WordPress.  Is my backup methodology sound?  One thing that I think I share in common with all bloggers:  I would hate to lose what I have created.  One of these weeks I should test the restore scenario in the lab to make sure it works.


No comments

  1. Troy says:

    I would backup your WordPress directory (small if I remember correctly) too if you have configuration options set there.

    Just to remove any doubt about what the current working configuration is at disaster recovery time.

  2. jason says:

    I have nightly differential and weekly full backups of the blog directories themselves.