Migrating MySQL 5.0.x to 5.1.x

Sam Sharpe lists.redhat at samsharpe.net
Thu May 20 07:09:28 UTC 2010


On 20 May 2010 07:26, Kevin J. Cummings <cummings at kjchome.homeip.net> wrote:
> On 05/20/2010 02:11 AM, Sam Sharpe wrote:
>> On 20 May 2010 05:24, Kevin J. Cummings <cummings at kjchome.homeip.net> wrote:
>>> Incorrect key file for table 'host'; try to repair it
>>
>> 1) backup a copy of /var/lib/mysql/mysql/
>> 2) myisamchk -r /var/lib/mysql/mysql/*.MYI
>> 3) try starting MySQL
>
> Fails with the exact same messages in /var/log/mysql.log
>
>> 100520 02:22:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
>> 100520  2:22:40 [Note] Plugin 'ndbcluster' is disabled.
>> /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
>> 100520  2:22:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
>> 100520  2:22:40  InnoDB: Started; log sequence number 0 13634811
>> 100520  2:22:40 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'host'; try to repair it
>> 100520 02:22:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
>
>> assuming it now starts, then run mysql_upgrade

Bugger.

This looks like a F10 -> F11 problem as googling for "Fatal error:
Can't open and lock privilege tables: Incorrect key file for table
'host'; try to repair it" takes me to this post:
http://forums.fedoraforum.org/showthread.php?t=225038

And here's the bug about it:

https://bugzilla.redhat.com/show_bug.cgi?id=493160

You could try:

mysqld --skip-grant
mysql_fix_privilege_tables
mysql_upgrade

But I honestly don't hold out much hope - the BZ advice seems to be
revert to F10, run mysql_upgrade, install F11, run mysql_upgrade :o(
-- 
Sam


More information about the users mailing list