Tuesday March 7, 2006 JST

A Hard, Hard Lesson Learned on Backups

In my recent post, I mentioned I had earlier posts elsewhere, which I was going to move here. But with so many posts (including lots of photos), and being on an uber-slow Internet connection, I decided not to use WordPress’ in-built importer … but rather make the switch via database.

So I went ahead to make a backup of my WordPress database. And having once been bitten, I did not want to take any chances at all this time. So I kept a copy of the database on my USB stick, a copy on my local machine, another copy on the webserver, and yet another copy in my Gmail account.

With these backups-of-backups, I reckoned I was safe enough, and went ahead to clean-up GeorgeAppiah.com, preparing the way for it’s pending assignment.

And today when I finally made time to upload my database to this new blog … grrrrrrrrrrrr. None of the 4 copies of the database I had on different media would work. Try, try, try … nada, nada, nada.

So the lesson here? Yes … make regular backups: databases, files, whatever. And yes, backup your backups too. But most importantly, test your backups before storing them.

Linkblog

Asides, methinks

    WordPress database error: [Table 'wecblogs_georgeappiah.wp_post2cat' doesn't exist]
    SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE wp_posts.post_date <= '2009-01-05 21:42:20' AND ( wp_posts.post_status = 'publish' OR wp_posts.post_status = 'sticky' ) AND wp_posts.post_password = '' AND ( wp_post2cat.category_id = '2' ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 20

Sweet 'n Del.icio.us Links