Backup Your Blog Regularly

Daniel Scocco

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.

Start Your Free Trial Today!


Browse all articles on the WordPress category or check the recommended articles for you below:

65 Responses to “Backup Your Blog Regularly”

  • Sondan

    How do I backup my WordPress Hosted (WordPress.com) 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

  • Mieke Janssens

    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?

    Greetz!
    Mieke

  • Jonas

    Hi, there is a new blog backup service at http://blogbackupr.com

  • dafodilkemmy

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

    Click here

  • Yong Hwee

    I’ve just started a new blog and this will come in handy in future. Thanks!

  • Mike

    I just wrote this handy little script that you may find useful…

  • William Profet from OneJobTwoSalaries.com

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

    Make it a ritual and do it frequently!

    Regards,
    William

  • Mike Panic

    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.

  • Daniel

    Michiel, send me an email and I will try to help you out over IM.

  • Michiel

    Still don’t know how to do this.
    I’m not familiar with all the expressions, you see.

  • GoddessCarlie

    I use the plugin to automatically backup my stuff every day. 🙂

  • SteveL

    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.

  • Jeremy Steele

    SteveL – That is what i do for my sites. works like a charm

  • Daniel

    P.C., good point :).

  • P.C.

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

  • Dana

    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 🙂

  • Daniel

    SteveL, I never used that feature, but I guess it should work as well.

  • SteveL

    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.

  • Genesis

    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!

  • OneYearGoal.com

    Thanks for the tip.
    I recently installed a plugin that pretty much wiped out my hosting account. I wish I’d followed your advice then.

    One Man. One Year. $100,000 online. How’s he doing it?
    http://www.oneyeargoal.com

  • Daniel

    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!

  • Bushido

    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.

  • Patrick Altoft

    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):

  • Jeremy Steele

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

    Very good point, hopefully the Google Bot visits often.

  • Stephen

    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.

  • dEEPAK

    yup Daniel.. I backup my database too..
    And Jeremy has a good point here about database backup every 2 days..

  • Daniel

    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.

  • Jeremy Steele

    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.

  • Daniel

    dEEPAK, notice that saving the site files alone will not backup your database. I think you know that though.

  • dEEPAK

    yup.. even I backup my blog weekly.. I use the method described by you i.e via http://FTP..
    Actually I’ve set a reminder on my cell phone to backup my blog 🙂

Comments are closed.