Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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!

share|improve this question

2 Answers 2

up vote 3 down vote accepted

Confirmed as bug, patch and details here

share|improve this answer
    
Thank you very much! –  ThaKidd Sep 17 '11 at 20:31

connect to mysql server and do a commands

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

etc...

share|improve this answer
    
Gave that a shot but unfortunately it did not resolve the problem. –  ThaKidd Sep 17 '11 at 17:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.