Database Debacle
It seems that a recent RHEL4 update downgraded MySQL from 5.0 to 4.1. Not cool, but it’s my fault. I should have added mysql* to the package ignore list. Most of the databases are okay, but three of them have tables that are unreadable. I’m working on restoring them now.
UPDATE 2:50pm: I decided not to re-install MySQL 5.0. Instead I used the latest good database dumps to restore the affected tables. This should serve as an excellent argument for keeping sql dumps of your databases along with the binary backups. The raw db files would have done me no good because they aren’t backwards compatible. The sql dumps are much more useful.