• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
Daily Blog Tips

Daily Blog Tips

How to make money from your blog

  • Home
  • Popular
  • Contributors
  • About
  • Contact / Advertise
  • Blogging
  • Marketing
  • Design
  • Money
  • Reviews
  • Productivity
  • Software
  • Technology

Backup Your Blog Regularly

By Daniel 40 Comments Reading Time: < 1 minute

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.

Backup Your Blog Regularly Photo

About Daniel

Daniel Scocco is a programmer and entrepreneur located in São Paulo, Brazil. His first company, Online Profits, builds and manages websites in different niches. His second company, Kubic, specializes in developing mobile apps for the iOS and Android platforms.

Reader Interactions

Comments

  1. Avatar of Make Money Easy OnlineMake Money Easy Online says

    at

    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.

    Reply
  2. Avatar of Digitalmalay Digital IssuesDigitalmalay Digital Issues says

    at

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

    Reply
  3. Avatar of ArmandArmand says

    at

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

    Reply
  4. Avatar of Bang KritikusBang Kritikus says

    at

    Thanks Daniel, good point to prevent our blog and folder from accident

    Reply
  5. Avatar of Computer BackupComputer Backup says

    at

    yeah, theres really no excuse for not doing it, especially when you can do it for free.
    -jack

    Reply
  6. Avatar of Sheraz AhmedSheraz Ahmed says

    at

    Hi I am searching blog backup utility.
    Can u tell me about WP-DB-Backup, what is this?

    Reply
  7. Avatar of DarjinfoDarjinfo says

    at

    Thanks for the info, very useful… i am using WP-DB-Backup and it is quite handy.

    Reply
  8. Avatar of Richard X. ThrippRichard X. Thripp says

    at

    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.

    Reply
  9. Avatar of Computer BackupComputer Backup says

    at

    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.
    -Mikey

    Reply
  10. Avatar of FT Lauderdale Real EstateFT Lauderdale Real Estate says

    at

    ohh, i havent backed up in a while, thanks for the reminder

    Reply
  11. Avatar of Blog Backup AddictBlog Backup Addict says

    at

    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.

    Reply
  12. Avatar of NgaragNgarag says

    at

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

    Reply
  13. Avatar of SondanSondan says

    at

    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

    Reply
  14. Avatar of Mieke JanssensMieke Janssens says

    at

    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

    Reply
  15. Avatar of dafodilkemmydafodilkemmy says

    at

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

    Click here

    Reply
  16. Avatar of Yong HweeYong Hwee says

    at

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

    Reply
  17. Avatar of MikeMike says

    at

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

    Reply
  18. Avatar of William Profet from OneJobTwoSalaries.comWilliam Profet from OneJobTwoSalaries.com says

    at

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

    Make it a ritual and do it frequently!

    Regards,
    William

    Reply
  19. Avatar of Mike PanicMike Panic says

    at

    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.

    Reply
  20. Avatar of DanielDaniel says

    at

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

    Reply
  21. Avatar of MichielMichiel says

    at

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

    Reply
  22. Avatar of GoddessCarlieGoddessCarlie says

    at

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

    Reply
  23. Avatar of SteveLSteveL says

    at

    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.

    Reply
  24. Avatar of Jeremy SteeleJeremy Steele says

    at

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

    Reply
  25. Avatar of DanielDaniel says

    at

    P.C., good point :).

    Reply
  26. Avatar of P.C.P.C. says

    at

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

    Reply
  27. Avatar of DanaDana says

    at

    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 🙂

    Reply
  28. Avatar of DanielDaniel says

    at

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

    Reply
  29. Avatar of SteveLSteveL says

    at

    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.

    Reply
  30. Avatar of GenesisGenesis says

    at

    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!

    Reply
  31. Avatar of DanielDaniel says

    at

    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!

    Reply
  32. Avatar of BushidoBushido says

    at

    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.

    Reply
  33. Avatar of Patrick AltoftPatrick Altoft says

    at

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

    Reply
  34. Avatar of Jeremy SteeleJeremy Steele says

    at

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

    Very good point, hopefully the Google Bot visits often.

    Reply
  35. Avatar of StephenStephen says

    at

    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.

    Reply
  36. Avatar of dEEPAKdEEPAK says

    at

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

    Reply
  37. Avatar of DanielDaniel says

    at

    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.

    Reply
  38. Avatar of Jeremy SteeleJeremy Steele says

    at

    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.

    Reply
  39. Avatar of DanielDaniel says

    at

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

    Reply
  40. Avatar of dEEPAKdEEPAK says

    at

    Actually I’ve set a reminder on my cell phone to backup my blog 🙂

    Reply

Leave a Reply Cancel reply

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

Primary Sidebar

Trending Today

Popular

  • 28 Ways to Make Money with Your Website 514 Comments
  • 43 Web Design Mistakes You Should Avoid 474 Comments
  • 4 Steps to Increase Your Blog Traffic 188 Comments
  • How to Find Advertisers for Your Website 126 Comments
  • Top 25 SEO Blogs 243 Comments
  • 101 Blog Tips I learned 177 Comments
  • 30 Traffic Generation Tips 351 Comments
  • 6 Ways to Speed Up Your Site 51 Comments
  • 9 Hacks to Show Readers Your Best Stuff 21 Comments
  • 50 Simple Ways to Gain RSS Subscribers 145 Comments
  • The Best Website Taglines 127 Comments
  • What Is Success? 57 Comments
  • How to setup a 301 Redirect 52 Comments
  • The 7 Characteristics of Good Domains 76 Comments
  • 7 Ways to Promote your Site 133 Comments
  • Top 25 Celebrity Blogs 44 Comments
  • What Is A Blog? 81 Comments
  • Blog Setup: 40 Practical Tips 57 Comments
  • 10 Tips To Write Your Most Popular Post 79 Comments
  • The Blog Post Checklist 75 Comments
  • Interview: 12 Top Online Entrepreneurs 98 Comments
  • What Is Bounce Rate? 42 Comments
  • 20 SEO Terms You Should Know 28 Comments
  • How To Choose A Blog Name 15 Comments
  • 10 Tips to Sell Your Website on Flippa 37 Comments
  • Top 25 Web Design Blogs 80 Comments

Online business done right. Take your marketing efforts to the next level with tips and resources to get visitors to your website.
As featured
CNBC copyblogger problogger Entrepreneur Lifehacker Hubspot Business Insider Wordpress Showcase
Privacy Policy| Terms of Service | About | Contact

777 Brickell Ave #500-14648, Miami, FL, 33131, US
DBT Logo
DBT is an independent website. The views expressed on this site may come from individual contributors and do not necessarily reflect the view of DBT or any other organization. All Content Copyright ©2006-2023. Daily Blog Tips unless otherwise noted or credited.