Encountered this error when dropping a table on a database that had recently been migrated from 5.0 to 5.5:
1 |
Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted; |
The migration used a “mysqldump –all-databases” so it included the “mysql” database. Apparently the “mysql.proc” table changed between the versions. The fix on the new server is to run:
1 |
mysql_upgrade --force -uroot -p |
I didn’t figure this out … instead Daniel Tillett gets the credit.