Home / server / Questions / 312538
Accepted
ThaKidd KG5ORD
Asked: 2011-09-18 09:16:45 +0800 CST

Weird MySQL Errors After Distrib Upgrade (SQL 5.0 > 5.1)

  • 772

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!

mysql myisam debian-squeeze mysql5

2 Answers

  1. Best Answer

    Confirmed as bug, patch and details here

    • 3

  2. connect to mysql server and do a commands

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

    etc...

    • 0