After hearing the horror story of one of my twitter followers, I had decided to make sure I was backing my blog up more frequently than every week. I had been doing manual backups via WordPress Tools -> Export function weekly to keep a backup of all my posts and a full copy of my dragonblogger web server folder during each wordpress upgrade.
I decided to do some research and find some automatic ways to upgrade wordpress instead.
My favorite plug-in I have found is called “WordPress Database Backup” by Austin Matzko, which allows you to select each individual table in your wordpress database and schedule emailed backups of your standard tables, plus any additional custom ones that are created.
Once you download and install the plug-in, you click on your Tools -> Backup in your WordPress Admin.
You then select how often you wish to backup your blog and which email address should receive the backup file.
Here is a screenshow showing my backup, including my custom DMZGuestbook table.
The backup will be taken about 24 hours after you select the setting and click submit, so if you installed the plug-in and configured it at 3:30pm then your first backup and subsequent backups will email at around 3:30pm in the afternoon thereafter. I was waiting for my backups of my blogs to come, and sure enough they arrived in my email accounts full attached.
This now saves me from having to do a manual “export” of my wordpress database and I am never more than 24 hours behind should I lose my blog. In addition if you wish to transfer your blog to another hosting company, you can use this backup file to import all of your posts.
Reminder, this only backups up your database information (posts, comments…etc) your plug-ins, wordpress themes and static pages are all physically located on the hosted web server and you will need to back those files up manually, the wordpress “export” doesn’t grab those files either, so to truly backup 100% of your blog including the theme and plug-ins you need to use this database backup, plus backup your local files for your wordpress install.
-Dragon Blogger
Related posts:
- Backup Your WordPress Blog Regularly My friend Damien Riley sent me an email the other day reminding friends to backup your wordpress blogs manually at...
- Migrating WordPress Blog to New Hosting Provider Part 1 – Backing Up Backing up your existing Wordpress Blog SQL Database and files is crucial to moving it to your new hosting provider....
- My First Time Using WordPress Automatic Upgrade Plug-In I had downloaded the “WordPress Automatic Upgrade” Plug-in because I did want to simplify wordpress upgrades since I had never...
- WordPress SQL Demonstration This demo will show you what your Wordpress SQL Database looks like behind the scenes and will cover a few...
- Using Handy Backup to SafeGuard your Windows PC Handy Backup software allows you to sync, backup your Windows OS and all documents and personal files. Backup across the...
| via FaceBook, Twitter, RSS or Email |  |
Enter your email and subscribe now!
Tags: backing up wordpress, backup wordpress, backup wordpress database, backup wordpress posts, Best Wordpress Plugins, wordpress automatic backup, wordpress plugins, wordpress post backup, wp database backup
April 10th, 2009 at 9:05 am
This is a nice tip. I’m going to try this as well.
arks last blog post..Phoenix Suns Eliminated From 2009 NBA Playoffs
[Reply]
April 10th, 2009 at 1:31 pm
I already try “Wordpress Database Backup” plugin, but i’m still worry that the plugin fail or do some mistakes so i always backup from my webhost. It make me more relieve than using that plugin. But still its up for the web owner to use whatever the method as long as don’t forget to always backup your site.
DeViLnoAnGeL InFos last blog post..What is The Benefits of Social Bookmarking ?
[Reply]
April 10th, 2009 at 2:46 pm
The plugin is a raw sql backup, and you need to use a phpmyadmin or a sql string to import it, wordpress is very good too, but the sql backup will actually make it more portable to other sofware as well based on SQL. I haven’t tested a restore yet, and I still do a manual backup, but I compared the manual export file size with the size of the sql backup and they are nearly identical, and it would seem by visually inspecting the file everything is there.
[Reply]