WordPress Database: Back it Up!

Disclaimer: This isn’t the sexiest, most glamorous post but it’s an important one. Most of you WordPress users are probably already familiar with performing a WordPress Database Backup but if I can save just one person out there the misery of losing all of their beloved content, then so be it!

If you’ve been blogging long enough, common sense tells you to back up all of the content on your server including photos on a regular basis. For years, I’ve been religiously doing this. BUT! Amazingly enough, I didn’t realize that I was supposed to be doing a SECOND, equally important backup until quite recently.

If you use the WordPress platform (such as I do), your WordPress Database contains all of your posts, comments, and links. In essence, it’s the content that gives your blog its unique format. A database backup may be the only saving grace if you ever install a bad plugin, have an upgrade go terribly wrong or get stricken by hackers. It’s better to be safe than sorry!

Conveniently enough, a a free plugin can do all of the work for you. To use it, simply download the plugin, upload it to your plugins folder on your server and activate it.

wordpress backup database blogging


Next, go to the Tools tab in the left column of your dashboard and click on Backup.

Once you’re in the Backup Options screen, scroll down and click on Download to your computer. It will do the rest!

Once you have a full backup, I would recommend scheduling regular backups from now on. Scroll down to Scheduled Backup and click the frequency (I do once a week) and make sure your correct email is on file.

wordpress backup database blogging

Now, you can have peace of mind knowing that all of your hard work is tidily zipped for safekeeping.


nubby twiglet signature

24 Responses to WordPress Database: Back it Up!

  1. Alice says:

    Wow, thank you for writing this, I recently started a blog and this is something I didn’t even think about. Without you, I would have had to learn this the hard way…

  2. As soon as I read this, I promptly did this and it does feel so much better to see my files in one place. Sometimes through the craziness of blogging whether you are new or established at it, you forget the little important tasks. Thank you very, very much for this post.

    On another note, your blog is wonderful and I’m happy that I came across it early last year. I love your Link Love posts in particular! It’s hard to see everything online and you always seem to round up a nice variety of subjects that I like! Take care :]

  3. Nubby says:

    Alice: You’re welcome. There’s so much else to worry about that sometimes we overlook backing up what we’ve already produced!

    Karen | imisutoo: Good for you. You’re exactly the type of reader who I wanted to reach through this. I’ve been blogging since 2007 on my site and nobody ever told me to do a database backup! I guess to everyone else around me, it was common sense! Ahhhh.

    Kiersten: Me too. They can do EVERYTHING. Love.

  4. Krissy ♥ says:

    Thanks for sharing this tip! I used to go into my actual SQL database to back everything up and it’s a paaain in the rear end, let me tell you. So this makes things way easier. :D

  5. Luke Copping says:

    Backup complete! makes me feel a little less crazy that this plugin auto schedules. Being a photographer I already have enough backups on my plate. So this sort of takes some of the thought out of it. Great recommendation.

    • Nubby says:

      Luke: Glad to hear that you’re getting all backed up. Running our own businesses means that we have enough to worry about and this is one less hassle.

  6. Pingback: BACKUP your Wordpress database!! (don’t just set it and forget it)

  7. Janine says:

    Perfectly timed. The first time I tried to click this I got some (maybe unrelated) virus protection spam site and freaked out a little bit but when I loaded your site directly today there was no problem. Just backed up and feel better. (I also downloaded my uploads via FTP and saved an export file this week – very paranoid.)

    • Nubby says:

      Janine: Yeah, I’ve had some issues with the site lately…everything should be permanently sorted by this weekend. When you think of the amount of time and hard work you put in to producing content, it does bring up some paranoia if you consider what would happen if you potentially lost it all!

  8. Pingback: Sunday Link Love - Alternative Housewife

  9. Pingback: Nubbytwiglet.com » Blog Archive » The Tale of GoDaddy, Ukranian Hackers and One Wordpress Blog

  10. Ally says:

    Came back to this post after setting up a website for my man’s band through WordPress. Thanks for the link! I’ve installed the plugin and appreciate you sharing it.

  11. Lara says:

    Hey! Thanks so much for this post! I remember when you posted this but I was still on WordPress.com. I finally switched to a new host and got everything transfered today and had to search for this! You may have saved my sanity some time in the future!

Leave a Reply

Your email address will not be published. Required fields are marked *

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

Please note: Any comments deemed inappropriate (spam, off-topic, rude language) will be removed.