New Media Interchange

Question: How do I make automatic backups of my WordPress blog database?

This post originally appeared in Careers in New Media

?

NMI Founder, Douglas E. Welch gets lots of New Media questions every day and here is a one from today…

  • Q: How do I easily backup my WordPress database (the file that holds all your posts, comments, etc). Why should you backup your WordPress Database? If not, am I in danger of losing all my blog posts due to hacking, upgrade issues or other technical mistakes?.
  • A: Yes, failing to backup your WordPress database could lead to the loss of all your blog content if there is an issue. There are a variety of ways to backup your WordPress database. The usual method is to use the database manager page at your web host’s site to manually run a backup to a text file and then download the text file. Doesn’t sound very easy or fun, does it. When I switched over to WordPress a few years ago I was determined to find an easier, and more automatic way, to do backups.

    Enter WordPress Database Backup, a free WordPress plugin available from austinmatzko.com.

    On each of your self-hosted WordPress blogs, download and install this plugin and then activate it via the WordPress Dashboard. Once installed, you can force an immediate backup that can be downloaded to your local computer or, and I prefer this method, an automatic backup which wakes up and then emails the backup file. I keep a separate Gmail account just for this purpose.

    Now, whenever there is a WordPress upgrade, I check to make sure there was a recent automatic backup and then proceed with the upgrade, secure in the knowledge that all my content is safe.


Do you have a question? Why not drop Douglas a line? Use the Comments link above, send email to me@douglasewelch.com or call the voice mail line at 818-804-5049.

Advertisements

Filed under: Elsewhere, Member, New Media, Question and Answer, Real World Example, Wordpress

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: