Just updated Debian from Lenny to Squeeze on one of my servers. It hosts a MySQL server. Upgrade went fine, but afterwords, when MySQL starts up, it checks the databases to make sure they are okay. I am getting errors though for tables that are in the mysql database.
I did an extensive Google search and attempted to do a myiasmchk -r to those tables. Outside of that, I have not found any other possible answers.
Is this just a bug? Is there a way to fix it?
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'columns_priv'; try to repair it
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'db'; try to repair it
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'func'; try to repair it
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'host'; try to repair it
ERROR 1034 (HY000) at line 1: Incorrect key file for table 'tables_priv'; try to repair it
Thanks in advance for your help!