A pretty bad week for databases.
After nearly killing a client’s DB yesterday (and spending most of my night restoring every bits and pieces semi-manually), I felt it wise to secure my own DB here. The one that stores this blog. Guess what happened then?
Yea, I blew the DB too. Or to be more precise: mySQL blew the part of the DB encoded in Japanese.
Here again I just spent half my night recovering everything that could be. Unfortunately all Japanese content for entries posted in June and early July is lost for good: not like it had much literary value, but still a bummer. And in case you are wondering about backups: believe me, I have backups, hundred of them… It just turns out that this piece of crap SQL isn’t even able to properly back up an exact binary copy of your tables that won’t screw up when it encounters encodings it can’t handle properly. So every single backup I have, is identically screwed.
My last personal piece of advice to any mySQL user out there, is to stay away from mysqldump do a freaking binary copy of the db files directly.