How to Automate WordPress Database Backup
When ever I talk about WordPress security, I always mentioned how important it is to take timely backup of your blog. There are many tools like ManageWP, Vaultpress, which let you take complete backup of your WordPress blog, but in this case we are only looking at taking WordPress database backup. There are many plugins like Wp Db-backup, Wp Db-manager, which will quickly let you take backup of WordPress blog database. Out of all, I find Wp Db backup to be easiest plugin, as it doesn’t require any configuration, and once you schedule your backup timing, it will keep taking backup after constant time-period.
In this guide, we will learn how to use Wp db-backup WordPress plugin, and start taking backup of your blog. Do remember, a backup is incomplete without your Wp-content folder backup, and if you are using a secure hosting like Hostgator, Bluehost, you are good with regular backup of database and wp-content. Database backup is more important, as in many cases database file get corrupts, and only way to restore it is via a backup file.
How to use WP Db-backup to Schedule WordPress database backup?
The first thing which you need to do is, install Wp-db backup plugin on your blog. (Learn how to install WordPress plugin). Once you have installed and activated the plugin, you need to click on Tools > Backup and configure the settings. Here you can take the instant database backup, or schedule your backup.
So, lets learn how you can schedule WordPress blog database backup:
Simply scroll down on the page, and under schedule backup, configure the settings. You can select how often you want to take database backup, and you will get a list of tables created by other plugins, which you can include or exclude from backup. I would recommend to select all tables, as it will make sure that you don’t face issue when restoring from database backup.
Once you have configured the schedule backup option, click on save, and this plugin will automatic taking backup of your Blog. This is not only important, but an essential task for any WordPress blogger. Along with it, if you want to take instant database backup of your WordPress blog, you could do the same from settings > backup. Here is a video tutorial for using Wp-db backup plugin:
This is one plugin, which I use on several WordPress projects, and find it very handy. I also used Wp db manager plugin, but that plugin requires few settings, and doesn’t work in all hosting environment. Now, it’s your turn to let me know, what method you are using to take backup of your WordPress Blog?
How WPEngine Hosting Helped Me To Recover ShoutMeLoud Blog
If you have read my earlier experience of moving to WpEngine, I mentioned why I decided to pay $450/month for…
CMS Commander Review – WordPress Bulk Management Service
When we take our first baby step into the world of Blogging, we all start with one blog, and with…
How I Unhacked WordPress Blog Using Sucuri Security Plugin
Any website which is hosted on a web-server is always vulnerable to hacking, and as a webmaster it’s our role…
How To Prevent WordPress Spam Comments With Smartness And Plugins
Spam comments is one of the biggest pain to a blogger and tacking them is part of our day-to-day life.…