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 · 4 Comments
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: , , ,

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