Automatic backups of your WordPress databases?
October 2, 2008 by Andy
WordPress is a fantastic tool for creating any type of website. However, servers can crash, MySQL databases can get corrupted and gremlins can get into the works!
With traditional websites built in HTML, you have always had the option of keeping a backup of your site on your hard disk. With WordPress it’s not so easy, as there aren’t physical pages you can backup. The pages are all stored in the mySQL database until required, and then built when requested. Keeping backups is therefore something that a lot of people skip, because they think it is too hard. Well, the good news is, those people are wrong.
Every week I am sent fresh backups of my blogs automatically, straight to my inbox, and I want to show you how easy it is.
The first thing you need is a plugin called WP-DB Manager.
Download and install the plugin. If you need help installing WordPress plugins, see my Installing Plugins in WordPress tutorial.
Once installed, you’ll have a new menu item in your WordPress Dashboard called “Database”:
If you open the main “Database” menu, you’ll see a lot of options. The one you need to open is DB Options.
Once the screen opens, scroll to the bottom to the Automatic Scheduling section:
The important sections here are highlighted in the screenshot. First, define how often you want the database backed up. I have it scheduled for once a week on blogs I post to weekly, and more frequently for blogs I post to daily. You can select an option to have the backup zipped.
Next, enter an email address to get the backups sent to. Once this is filled in, the plugin becomes active as soon as you save the changes. However, before you save, there is one other option – automatic optimizing of the database. I have this set to once a week on all of my blogs.
Once those pieces of info are entered, scroll to the bottom and hit the “Save Changes” button.
Once saved, you can scroll back down to the Automatic Scheduling section and you’ll see the “Next Backup Date” and “Next Optimize Date” are now filled in with the dates of the next automated backups.
You can now sit back and wait for the plugin to send you automated backups. I have a mail filter setup in my mail client to automatically file those emails in my Blog Backup folder.
Print This Post
Related Articles
- Top 12 WordPress Plugins For WordPress 2.7.x - Here is my top 12 WordPress plugins for WordPress 2.7.x Bookmark on Delicious Digg this post Recommend on Facebook Buzz it up Buzz it up share via Reddit Share with Stumblers Tweet about it Subscribe to the comments on this post
- Manual Upgrade of WordPress - It has happened a few times to me. The automatic upgrade plugin for WordPress hasn’t worked. The last time this happened was with WordPress release 2.6.1. and it happened on all of my blogs. Is it a hosting issue, or a plugin issue? I am not sure, but what I am sure about is that
- Top 10 WordPress Plugins - NOTE: This article is quite old. On 10th May 2009 I posted a new article with an update of what plugins I use. The article is Top 12 WordPress Plugins Here is my top 10 WordPress Plugins. I do use others, but these are the first ones I install when I setup a new WordPress site. 1.
- Installing WordPress - Installing WordPress is very easy. If your webhost has Fantastico installed, you can do it with a few clicks of the mouse. For some hosts, you will need to manually install WordPress, including creating a MySQL database, editing the WordPress config file, uploading everything, and installing. This is also very easy, in fact, it
- Creating a homepage in WordPress - If you have installed WordPress and the plugins recommended in my Top 10 WordPress Plugins article, you ‘ll currently have a blog that looks like the generic WordPress blog, containing a hello world post, and an about page. Note: You can click images to enlarge them. We still have a fair bit of customizing to
Comments
One Response to “Automatic backups of your WordPress databases?”Trackbacks
Check out what others are saying about this post...[...] The plugin actually emails you a backup every week (or at the interval you define). Automatic backups of your WordPress databases is a tutorial I created showing how to set this automatic backups [...]