Maria’s Guides

Support and additional material for readers of books, articles, and digital media by Maria Langer.


Random Book Cover #1Random Book Cover #2Random Book Cover #3Random Book Cover #4Random Book Cover #5Random Book Cover #6Random Book Cover #7Random Book Cover #8Random Book Cover #9

Backing Up a WordPress Blog Database

Posted on September 15th, 2006 at 6:00 am ·
Filed in: RSS WordPress Books   

Back it up — just in case.

It happens more often than you think. Your server’s hard disk dies and takes all of its content to byte heaven.

Of course, it never happens when your files are backed up. So by backing up your files, not only do you have a copy of your hard work in case it does happen, but it’s less likely to happen in the first place.

Two good reasons to back up your WordPress database.

These instructions apply to WordPress.com server installations.

Step One: Make sure the Backup plugin is activated.

You only need to do this once.

  1. Log into your blog and display the dashboard.
  2. Click the Plugins button in the navigation bar.
  3. Confirm that the WordPress Database Backup plugin is activated. If it isn’t click the Activate button in its row.
    The Backup Plugin

Note that if the WordPress Database Backup plugin does not appear in the list, you must install it. You can get it from Skippy.net. We explain how to install plugins on pages 152-153 of our WordPress book.

Step Two: Back It Up

You do this each time you want to back up the database.

  1. Log into your blog and display the dashboard.
  2. Click the Manage button in the navigation bar.
  3. Click the Backup button in the second row of the navigation bar.
  4. Backup OptionsIn the Backup administration panel, turn on all of the check boxes on the right side of the window. Keep in mind that you may have more or fewer check boxes than what is shown here. Select the Download to your computer option at the bottom of the window and click Backup! (If you get an error message here that your backup folder is not writable, you must change the permissions for the wp-content folder on your server so it’s writable. We explain how on pages 120-122 of our WordPress book.)
  5. Wait while the backup is created. It might take a while if you have a large blog. Don’t close the browser window while the backup is being created!
  6. Save FileWhen prompted, save the backup file to your hard disk.

You can automate this process by installing the WP-Cron plugin by Scott Merrill. This plugin, which I use on all of my WordPress blogs, can automatically back up your database nightly and e-mail you a copy of the file.

And since I’ve begun using it, I haven’t had a single need for those backup files!

Technorati Tags: , , ,

 • Read 205 Times
Add to Del.icio.usAdd to Del.icio.us • Technorati ThisTechnorati This • Digg ThisDigg This • Stumble ItStumble it! • Twit ThisTwit This


 

 

4 responses so far ↓

  • 1 WordPress Visual QuickStart Guide » Moving a WordPress Blog to GoDaddy Hosting Account, Part 2 // Sep 26, 2006 at 8:59 am

    [...] But if you’re living life in the fast lane and don’t back up regularly (or at all), follow the instructions my article titled “Backing Up a WordPress Blog Database” [...]

  • 2 George // Nov 13, 2006 at 9:14 am

    The perfect tool for your wordpress backup is SiteVault ( http://www.site-vault.com ). It takes a bit to configure but you can just forget about it until you need the latest backup restored ;).

  • 3 System Advancements at the Monastery » Blog Archive » WordPress and GoDaddy // Jan 10, 2007 at 9:24 pm

    [...] Maria Langer posted very good instructions, “Backing Up a WordPress Blog Database.” Maria Langer, author of “WordPress 2“, posted excellent instructions on moving WordPress over to Go Daddy in the posting, “Moving a WordPress Blog to GoDaddy Hosting Account.” Maria site is a good reference site on all matter involving WordPress. For another reference, another good source is the WordPress Community Podcast. [...]

  • 4 Security at GLORIAD » Blog Archive » WordPress and GoDaddy // Jun 21, 2007 at 7:37 pm

    [...] Maria Langer posted very good instructions, “Backing Up a WordPress Blog Database.” Maria Langer, author of “WordPress 2“, posted excellent instructions on moving WordPress over to Go Daddy in the posting, “Moving a WordPress Blog to GoDaddy Hosting Account.” Maria site is a good reference site on all matter involving WordPress. Another good source is the WordPress Community Podcast. [...]

Leave a Comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

If you have a Gravatar, it will appear beside your approved comment.
No Gravatar? Get one free!