…you must always back up. Yeah, I got that.
But then when you restore old backup files over perfectly good recent files, your data goes poof. Which is what happened to my blog this morning.
I upgraded my server software to the latest version of OSX, and breezed past the warning that if you use mySQL databases, you must export them before upgrading. So after the upgrade finished, my blog dates were all messed up. Apparently they reversed a mysql bug that did the same thing to me about six months ago. No big deal – I went back to the old OS, exported the databases, came back into the new OS and imported – and wiped out a good database with an older backup.
But you may notice that all of my old entries seem to be back! Well, I did a google lookup (obtainium justfred) and used the cached page, which was taken just a few days ago, and copy and pasted all the entries over. I think one was missing, but I don’t think I care.
Some of you may be saying (Nelson) “Ha, Ha!” Yep, some of these things still crap out on OSX. But – remember that step where I “went back to the old OS”? I just reinstalled the previous version of OSX on a spare hard drive, rebooted, exported data, rebooted, and was done! I would have no idea how to do this on Windows or Linux – on OSX it’s relatively trivial. I might even have used my iPod as a spare hard drive if I’d needed to. And it’s vanilla mysql I’m using as a database, so it’s really easy to do the data export and reimport – a single command line for each database. And I had several other databases that, while they still had this problem, I didn’t screw up on the repair so they came back up no problemo.