MySQL upgrade hosed existing tables...

[SHtRO]

We recently upgraded a server here from FC3->FC5 via FC4. Did not get everything reconfigured in FC4, and went straight to FC5.

Not many problems until today, just had to reconfigure a few services (HTTPD, Dovecot).

However, many MySQL tables are now hosed. Simple queries like "SELECT * from TableName" fail with the error: "can't find file 'TableName' (error 2)"

Repairing and checking don't work and there are table files there. This does not happen on all tables, but on many and I would like to recover without rebuilding if possible.

More importantly, this is a serious bug.

[icydog]

Uh oh. You are supposed to do mysqldump before upgrading. Perhaps you can try uninstalling mysql-server and installing the old version (whatever you used on FC3), reading the tables to do mysqldump, then installing the new one again and load the output of mysqldump into it.

[SHtRO]

Yeah, the backup dumps worked well, but it was a real pain. I worry about this mainly because upgrades can happen automatically and certainly the tables shouldn't be "semi-available" and "irreparable" due to a simple upgrade. Just a real nuisance.

[pete_1967]

You seriously tried to upgrade production database from one version to another with all databses live and expect all to work without hickups? Wow!