In this video tutorial, I’ll show you how to backup your WordPress blog’s database using the WordPress Database Backup plugin by Austin Matzko.
Keeping a recent backup of your blog is a mandatory step for bloggers. Set this plugin up to email you a copy of your database at least once a week. It’s good practice to keep database backups for at least 1 year.















December 18th, 2009 at 3:45 pm
Hi John
Great video, installation of plugin and which settings to use well explained.
Looks like a must have plugin.
I’m starting to prefer video tutorials to text and screenshots.
Did I notice Contact Form 7 there?
I messed around with CformsII for ages and eventually gave up. Contact form 7 was much easier to configure and its stylsheet is simple to modify.
Have you got rid of your CommentLuv plugin?
I was thinking about installing it and then noticed that yours had vanished.
December 20th, 2009 at 10:57 am
Actually, I don’t think we use the CommentLuv plugin on our television channel, but I use it on my blog.
Oh and I totally hear you on cforms II. I used that plugin for awhile on my blog and it was a nightmare for even me. I switched to Contact Form 7 and my life became much simpler.
December 24th, 2009 at 9:22 am
cool…Thenks
December 28th, 2009 at 1:59 am
this plugin is working great.
i had backuped my blog using this plugin.
January 3rd, 2010 at 8:56 am
Hi John
Gave it a go but had a few problems…
First was that the WP Firewall blocks the installation (sent me an email warning of attack), so I deactivated it and installed WP database backup.
Set the options pretty much like yours i.e download backup to computer and email scheduled backup to weekly.
Then when I hit backup now…. I had the blue progress bar indicating backup, which stopped at “preparing to download” but nothing after that!
Any thoughts plus when it downloads to your computer, where abouts on the computer does it download to?
January 3rd, 2010 at 10:32 am
Hi Keith.
Not really sure what the problem could be, I’ve never heard of that happening. Also, I use the firewall plugin just fine with the database backup plugin. There’s something else going on which I wouldn’t really be able to figure out without really looking into what you got going on.
My suggestion is to maybe try one of the other database backup plugins. There’s a few other good ones out there – just Google it.
As for where the file is saved to when you download it, that depends on how you have your browser settings set up. I have mine set up to always ask me “Where would you like to save this file to…”
January 3rd, 2010 at 11:11 am
Thanks John
No problem… I’ve been backing up database using phpMy Admin on Cpanel.
Only takes a couple of minutes.
I’ll try again later.
January 4th, 2010 at 12:19 pm
Hi John
Came across this article, which looked like the problem I was having.
http://wordpress.org/support/topic/310508
Article explains that they…. “I solved inserting *wp-admin/tools.php* and *wp-admin/edit.php* in the whitelisted pages.” for the Firewall plugin.
I’ve not tried it yet but it may help if anyone has the same problem.
January 5th, 2010 at 10:30 am
Hmm… ok they got it to work but only by bypassing a couple files which might be good to keep an eye on and protect.
Personally, I’d rather just use a different plugin to backup the database and leave those files untouched (i.e. not whitelisted).
January 5th, 2010 at 10:42 am
Hi John
I’ve learnt that whenever you say Hmm… you are a bit sceptical. LOL
I’ll take your advice and look for another plugin.
February 27th, 2010 at 3:08 am
Thanks
Nice tutorial….was quite helpful.
Have a question, that to restore it I have to import it to server or what?