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

?

I get a lot of 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 me a line? Use the Comments link above, send email to me@douglasewelch.com or call the voice mail line at 818-804-5049

Leave a Reply

Your email address will not be published.