Recovering from server failure and bad backups: the Internet remembers

Airmail Crash

Two days ago I received several emails notifying me that my sites were all down. Soon thereafter my VPS hosting provider emailed me to say my server, and numerous others, had all been lost, and they had no backups.

Unfortunately, my SQL backup system had been failing silently, and the latest ones were from February. Fortunately, all my filesystem data (pictures, templates, static files) were backed up constantly via Dropbox, so none of that was lost. But how to recover all my posts since February?

Google caches pages, so all my pages were archived there at least — but it’s quite clunky to pull down more than a few pages from their caches. Warrick promises to automate the process, but I couldn’t get it to recover my articles (though it worked fine for other pages). So instead I went to Google Reader — where my RSS feed has been archived going back years. I went through each missing article and sent it into Evernote to archive it. Then I tediously went through Evernote and cut & pasted my article back into WordPress with the correct date (and re-added images, which had been saved via Dropbox). Frustrating, but it’s working fine! (And I’ve switched hosting providers.)

The lesson? Validate your backups! And never give up if it seems like you’ve lost things online. The Internet remembers.

Share on FacebookShare on Google+Tweet about this on TwitterEmail this to someone

2 letters to the editor on “Recovering from server failure and bad backups: the Internet remembers

  1. Any particular reason you still went with “one article at a time” , instead of
    saving the entire GReader cached atom feed to a local file and import that
    file into WordPress ?

    Matti Meikäläinen
    • Matti,

      Mostly to give me more control over the re-import, such as making sure categories and tags were correct, images functioned, etc. Basically to help with quality control.

      Kristopher Nelson

Submit a Letter to the Editor

Letters to the Editor Policy

Letters to the Editor are welcomed and encouraged. Letters must be the original work of the author and may be edited for style, space, accuracy, and civility, but care will be taken to preserve the core of the writer's argument. Copyright in Letters submitted to the site and accepted for publication remains with the author, but authors grant this site the right to freely reproduce such material. Your Letter may appear in connection to an article or may become the basis of a new article. Not all letters will be published.