Biznik - Business Networking

Contact Us


Duct Tape Marketing

Duct Tape Book

Free Social Media for Business ebook

Social Media for Small Business
John Jantsch Marketing Coach
About John Jantsch

Recent Posts

Entire Archive

  • Categories

  • Categories
  • Is your blog backed up?

    mySql databaseI’m not referring to plumbing or digestion although that might make a more interesting post.

    I’m talking about good old practical, common sense, you know you should do it, but may not know how, backing up your blog posts, members, comments and trackbacks. It’s all the stuff that actually makes a blog a blog.

    Backing up important files is a smart business practice and many people extend that to backing up web site files. The thing that makes backing up a blog a little trickier is that you may have your blog design or theme backed up, but the posts themselves in most of the blog software reside in a database that may only exist on your host’s server.

    You need to take the extra step of exporting this data or backing up your mySql database.

    WordPress uses a mySql database and most hosts have some routine that allows you to back up and download a copy of your database. Here’s a great tutorial on backing up mySql from Wordpress

    Hosted blog software such as TypePad also has a feature that allow you to export all of your data and store a copy. TypePad export instructions.

    It may not matter, but if you invest a year of two in creating lots of great search engine friendly content it could be a real bummer to lose it all. Especially if you thought you had backed it up because you backed up your web site files.

    Your database files are particularly at risk during system or software upgrades. Just go do it and do it again on a regular basis.

    Like this post? Share it with others
    • Facebook
    • Twitter
    • LinkedIn
    • del.icio.us
    • Sphinn
    • Google Bookmarks
    • StumbleUpon
    • Digg

    Posted by: John Jantsch on Feb 24, 08 | 8:08 pm
    Category: Blogging, Social Media | Tags: , , , ,

    Comments
    • Really, really good advice, John.
    • May
      Always good to back up anything!!! :)
    • Actually, if you're on a self-hosted Wordpress blog, there's a plug-in by the name of "Wordpress Database Backup" that AUTOMATICALLY sends a .sql file of my database every Monday to my Gmail address. I could configure it to be more often if I wanted to, but I'm not a high-volume blogger, so weekly back-ups are just fine for me.

      It helped me the other day when something went screwy and WP couldn't see my db. I just re-created things and everything was Kosher.
    • You can easily backup your posts, comments, custom fields and categories by using the Export option on the Manage tab in the WP admin area. It saves an XML file that can be re-imported from the same menu.

      It makes sense to also backup:

      1) Your theme folder
      2) Images used in posts
      3) Plugins

      Cheers,
      Steve.
    • John Jantsch
      Steve, thanks - yes the theme is a big on since, even if it's a template, you've probably spent a fair amount of time hacking little tweaks to it.
    • John Jantsch
      Adam,

      Thanks I will check that plug-in out - I'm for anything that automates a process.
    • Andy,

      I hope you're not speaking from a bad experience!
    • For those of us on Blogger, CodePlex Blogger Backup by Greg Duncan is great. He's very accessible and always adding new functionality.

      http://www.codeplex.com/bloggerbackup
    • John Jantsch
      Lisa, Thanks for the Blogger tip, didn't mean to be noninclusive.
    • Businesses (whether blogs, or non-internet-based businesses) live or die by their data. Losing everything could amount to losing everything. I prefer off-site backups, as they protect against something catastrophic happening in the office / home.
    • The backup isn't just good for backups alone - it's also how you can move to another web host. I just signed up for HostMonster and had 3 outages (that I know of) in 3 days. So I'm moving my wordpress site to another host.

      The MySQL backup is ESSENTIAL for moving the site.
    • eddiepetosa
      I never considered backing up my blog. I'm using shared web hosting and Wordpress so I don't see why I can't make this happen. If any of you think it's impossible, please let me know before I try it and find out this for myself.
    • You are doing a great job by spreading the word, it's really very important!
    blog comments powered by Disqus


    Popular Searches


    Small Business Marketing Magazines


    Free - No strings attached - Business and Marketing Magazine Subscriptions

    Target Marketing
    CRM
    Internet Retailer
    eWeek
    Electronic Publisher
    Print Media and more


    Creative Commons License
    This work is licensed under a Creative Commons
    Attribution-NonCommercial
    -NoDerivs 2.5 License
    .
    Subscribe



    Subscribe to the Duct Tape Podcast
    subscribe via iTunes

    Duct Tape Marketing System

    Duct Tape Marketing System

    Duct Tape System - Complete small business marketing system in 14 workbooks and 4 audio CDs.


    Marketing Plan Pro powered by Duct Tape Marketing

    Marketing Plan Pro

    The Duct Tape Marketing System now comes as Marketing Planning Software. We teamed up with Palo Alto Software, the makers of Business Plan Pro, to bring you the most powerful small business marketing plan tool going. More info here . . .


    Referral Flood by John Jantsch

    Referral Flood by John Jantsch

    Referral Flood - How to create a flood of new business without spending one dime on advertising - by John Jantsch

    Subscribe to my weekly newsletter

    First Name * Last Name * Email *

    Connect Socially