Create Automatic Backup of WordPress Database
Like this article?
How would you feel if you wake up one morning and get to know that your WordPress blog has been completely crashed up and your blog database has been corrupted the situation become more aggravate if you don’t even have backup of your blog database.
All your articles and content which you had written so far has completely been vanished. This is not less than any nightmare, right?
But you can overcome this situation if make backup of your WordPress blog database on daily basis, though this is really a complicated task. However, to make this task more flexible and easy I am writing this article for all of you.
This article will guide through the steps on how to download backup of your WordPress Database and also schedule automatic backups for future.
How to Make Automatic Backup of Your WordPress Database:
1. First thing which you will need is “WP-DB-Backup” plugin, you can download this plugin from here.
2. Now after downloading this plugin install it in your WordPress blog by uploading plugin folder to your “wp-content/plugins/” directory and activate it using your WordPress Admin Panel.
3. Once you have activated this plugin Goto Tools -> Backup. Here you will find all the options and functionalities of this plugin.
4. By default this plugin will make backup of all core database table of WordPress but if you are using extra plugins then you may need to choose them under “Tables” section to include in backup wizard.
5. Now move on to “Backup Options” section here you will find 3 options, one will let you upload backup file on the server, second will let you download it on your computer and third one will let you mail your backup file to any email address.
6. This is how you can make backup and download/send it manually while one of the cool feature of this plugin is that you can schedule automatic backups and let it send automatically to your email address.
7. To setup automatic backup head over to “Schedule Backup” section at bottom and there you can select frequency on which you want backups to be generate, If you do post lots of articles in a day then you can choose Once Hourly or Twice Daily backup otherwise you can choose Once daily or Weekly options. Though, I would suggest you to choose “Once Daily” option.
8. Now in the next field enter your email address where you want database backup file should be emailed. And again like you did above, you can choose extra plugin’s database tables for backup and Hit “Schedule Backup” button and it will create and send a copy of backup right at that time and then afterwards it will automatically send backup to your email address on your chosen frequency.
Like this article? there are many to come so don’t miss them Subscribe to RSS Feeds or Follow me on Twitter.
Muhammad Qasim (October 24th, 2009)
very handy
Mohammad Farzan Hussain (November 14th, 2009)
Thanks, it’s really helpful plug-in. Just installed it on my blog successfully.
Tusker (December 9th, 2009)
I have used this plugin before and it works really well, but all it lacks is a functionality of files backup also. Are there any plugins out who can backup and email db as well as files on the public html folder also?
Vaibhav (December 24th, 2009)
I use this plugin and it automatically takes backup of my WordPress DB every week and optimized it every month.
Very Very important plugin, you never know when DB gets corrupted