One of the most basic routines we bloggers get to acquire as we grow and maintain our blogs is make regular backups of our blog’s database. This is important because when tragedy strikes like database crashes, WordPress or plugin updates and migrating blogs from one host to another, we can rest a little easier knowing that we could restore our blog to its most recent state thanks to that backup of the database.
However, this basic and important task is often times neglected and taken for granted by the casual blogger (read: the not so geeky ones) and so when tragedy does strike; frustration, despair and even financial loses are greatly magnified because we forgot to make an up-to-date backup of our blog database. I’ve read so many stories ranging from simple corruption of a few database tables to a major destruction of the database itself from different bloggers and these incidents are no laughing matter.
More than one solution
Thankfully, there are a number of solutions to remedy and mitigate this problem. One way of creating backups of our blog database is using the backup features of CPanel which powers most of webhosting accounts today. If you’re a hardcore techie, or simply the smart and adventurous one, there’s also the option of using phpMyAdmin in creating database backups.
For the rest of us, general bloggers, there are many WordPress plugins that allow us to create backups of our blog DB without getting under the hood of our hosting account. The most popular and widely-used plugin is Austin Matzko’s WordPress Database Backup plugin.
With this plugin, you can create backups of your blog database whenever we need to. This plugin has saved my blog a couple of times and I’ve never used another plugin that does the same thing. However, as I’ve said earlier, not all bloggers are that diligent with their blog maintenance and religiously creating backups of their blog DB.
Feeling lazy? Let the WP Database backup plugin do it for you
Fortunately, this plugin has one very, very neat feature and it allows us bloggers to schedule the automatic creation of our blog’s database backups. Say what?!
Yup, if you haven’t noticed yet, the bottom-half of the Backup creation page under the Manage menu is a section that allows us to do the following cool things:
- Schedule when a backup of our blog database is created
- Choose which database tables are to be included in the backup file
- Specify an email address where the plugin will send the backup file of your blog’s database
All of this requiring no action from you except for specifying the settings of the automated backup creation. Awesome isn’t it? Just set it and forget about it. You’d just recieve an email containing the backup file of your blog database as an attachment sent to you on the day and time you first set the whole function. Mine is set to create and send the database backups to my email every Sunday of the week.
Since I’m using my .com.ph email is powered by Gmail, I created a label+filter setup that automaticaly archives the mail sent by the plugin containing the backup file as an attachment. In effect I have created a weekly snapshot/timeline of my blog’s database so in case I need to restore my database, more than one option is available for me to choose from.
You too can enjoy the convenience of automating the backup creation of your blog’s database simply by enabling and customizing this feature of the WP Database Backup Plugin.
But wait, do you a different backup plugin? Does it have the same automated backup creation feature? Please, do share your stories. ^__^