1

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!

Community
  • 1
ThaKidd KG5ORD
  • 329
  • 1
  • 7
  • 17

2 Answers2

3

Confirmed as bug, patch and details here

Noam Kremen
  • 221
  • 2
  • 7
0

connect to mysql server and do a commands

repair table func; repair table db; repair table host;

etc...

Korjavin Ivan
  • 2,230
  • 2
  • 25
  • 39