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.
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.
I have nightly differential and weekly full backups of the blog directories themselves.