Backup Your Blog Regularly

by Daniel in 40 Comments — Updated Reading Time: < 1

Background Image

Creating backups of your blog is like drinking water. You know you should do it at regular intervals, but often times other activities get in the middle and you just forget about it.

The possible consequences of not backing up your blog, however, are much more serious than missing the middle-morning water glass. Should your server crash for some reason, or your websibe get hacked, you will lose valuable data.

Personally, I try to backup all my websites weekly (but I am lazy, so if you have time you can even do it daily!). Below you will find a quick checklist for backing up your blog.

  1. Use an FTP client to download all the site files (the WordPress folder)
  2. Log into phpMyAdmin and select your WordPress database
  3. Click on “Export” and make sure that all the WordPress tables are there
  4. On the “Structure” section tick “Add Drop Tables,” “Add AUTO_INCREMENT,” and “Enclose table and field names with backquotes”
  5. On the “Data” section leave all the boxes unticked
  6. Tick “Save as file” and download the database (you can use compression if your database is big)

If you don’t have access to phpMyAdmin, you can use the WordPress Database Backup plugin.

Share this article

40 thoughts on “Backup Your Blog Regularly”

  1. Am glad I found this post and I am taking Daniel advise.

    But can anyone teach me how to install it on my localhost so that I can go through some of the posts and after editing, upload into my server?

    Thanks in advance.

  2. Thanks man.I’m looking for this info.But i think it is wise to put some snapshot to make it more clearer

  3. Thanks for the tip. I guess it’s also useful when you’re going to transfer your current blog to another hosting services.

  4. I have a LiveJournal blog which I use the LiveJournal Crossposter plugin on. It automatically copies my posts to LiveJournal, updates them if I edit, and deletes them if I delete them on my blog. It will even has an option to cross-post old entries in the settings.

    Posting doesn’t seem any slower, and I have a running backup of my blog posts on LiveJournal.

  5. yeah and the good thing about backup is that a lot of companies offer it for free, or very cheap. its worth it… especially if you have files you cannot afford to lose or replace.

  6. This post (and its comments) supports the theory that most bloggers don’t backup their blogs. I cannot stress enough how this is important.

    Fellow bloggers heed the call. Back up your blogs now and regularly from now on.

  7. Great and interesting tip. This is a very helpful resource to all bloggers like me who don’t want to lose their blogs.

  8. How do I backup my WordPress Hosted ( blog database please? I recently had to restore about a dozen posts on my blog from the Google Cache and the Technorati Cache since WP couldn’t/wouldn’t get to my request to restore in entirety.

    I would love to have my own backup so that I don’t have to depend on anyone but myself to restore.

    Thanks in advance

  9. Hi

    Thanks for the great tips

    I’ve been looking for an easy way to back up my websites (including my blogs). Unfortunately if you have several sites on different servers, manually downloading all files takes up a lot of bandwith.
    My ISP only allows me to up- and download 10GB every month – when I backup all my sites once, I use half of that. And backing up only once a month is not such a good idea, since I’m pretty active :o)

    I was wondering if anybody knows any solutions that won’t require a full download every time again – so I can save my bandwidth to build my ebiz?


  10. Free Razr plus free shipping with activated service plan.Choose from AT&T, Nextel, T-Mobile, Verizon, and more.

    Click here

  11. The backup is one of the most important and the most postponed activity!

    Make it a ritual and do it frequently!


  12. Last week my web host went down for about 4 hours. Fearing the worst, I panicked because I had not made a backup in a long time. After it came back up, it was the first thing I did w/ the WP backup plugin.

    The one thing this article didn’t cover was – what to do with the backup. My day job is in IT, backing up several places is key. Keep a local copy on your computer and another on an external hard drive if you have one.

    What I’ve been doing is sending the backup copy of my site(s) to my Gmail account using the Gmail Space add-on for Firefox. Once in Gmail I use a filter to put it into a “website backups” archived area. If my server goes down and my home computer dies, I still have a copy of the website floating out there in the land of Google.

  13. Jeremy, it’s my preferred backup. I can watch it download, and store it on my own drive.

    Blue Host makes it a breeze via the Control Panel to upload either the whole directory or just the database.

  14. Great tips. Just don’t forget to backup all your computer files too, especially if that’s where you’re storing your blog backups!

  15. I use the WordPress Database Backup plugin to automatically back up daily. The zipped database file is emailed to my gmail account, in case my computer crashes.

    I back up my site files via FTP once a week by using the same backup program that I use to back up my computer. All those files are saved on an external hard drive.

    I like automation, no need to use the brain to remember 🙂

  16. What do you think about backing up your database and home folder from your Internet host?

    I use Blue Host, and their control panel makes both a snap.

  17. I learned this one the hard way when I lost one of my blogs by accident and my last backup was 3 weeks earlier! Luckily my host did have backups for the week before, so I managed to save most of the information (the rest I got off my feed reader which has my blogs on it). But now I do twice weekly backups!

  18. Bushido, I think you would be safer making a backup of the whole database. Apart from posts, it will also carry the comments and other tables required for plugins.

    Patrick, good one, exactly what I was looking for!

  19. Doesn’t WordPress have an option in the wp-admin menu that allows you to export all your posts to an XML file? You can the import that file from the same wp-admin menu and get all your posts back if you should lose them. I’m not really sure, though if it does the same to your comments as well.

  20. I run a script every 24 hours to back up the whole database and send it by email to my gmail account, the link to the script is here (its free):

  21. “you can often go into Google’s cache of your blog and recover it there.”

    Very good point, hopefully the Google Bot visits often.

  22. I think the best guideline wouldn’t be to back up ever week, but every few posts. The point, after all, is not to lose important data. Comments are nice and all, but it’s the posts you really don’t want to lose. I say back up after posting anything that took you more than a few hours to produce, be that a single evergreen post or several smaller ones.

    It’s also worth noting that, should you suffer a mishap and lose a post or two that you don’t have backed up, you can often go into Google’s cache of your blog and recover it there.

  23. Jeremy, yeah I should probably backup the database every couple of days or so. I am trying to setup an automatic backup for DBT, will keep you guys updated.

  24. On top of backing up your whole blog at least once a week, I’d also recommend backing up just your database data at least every two days. It really comes in handy if you get in a copyright dispute with someone.

    Plus think about it, if you server gets hacked and you only back up the database once a week, you may have to roll back an entire week. That can be really painful by itself, but imagine if one of those lost posts got Dugg.


Leave a Comment