Mysql 4.1 -> 5 upgrade ERROR 1017 (HY000)

[bmarshallbri]

I upgraded the mysql database server from 4.1 to 5.0.24 through WHM. Now a lot of my user databases are not working. I can see the schemas and the tables in the schemas in the mysql terminal. But when I try to query a table I get this for eaxmple:

ERROR 1017 (HY000): Can't find file: 'table_name' (errno: 2)

Lovely.

I found another thread from a guy who repaird the mysql schema, which tried to no avail.

as a test I tried restoring one of the databases from the cpanel backup. It fixed the first one I tried but no love on several others. Plus I'm thinking there has got to be something else going. I'm assuming that something did not quite happen right in the upgrade.

Can anyone help? Basically I'm totally down as far as my customers are concerned (they're a bit dramatic for a saturday night), but this doesn't quite fit my high availability motto.

[bmarshallbri]

not sure why but when I ran /scripts/mysqlup --force it all came back to life.

Maybe the second time is the charm!!