Migrating MySQL 5.0.x to 5.1.x

[Kevin J. Cummings]

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/

cp -R /var/lib/mysql/mysql /var/lib/mysql/mysql.bak

> 2) myisamchk -r /var/lib/mysql/mysql/*.MYI

> - recovering (with sort) MyISAM-table 'mysql/columns_priv.MYI'
> Data records: 0
> - Fixing index 1
>           
> ---------
> 
> - recovering (with sort) MyISAM-table 'mysql/db.MYI'
> Data records: 7
> - Fixing index 1
> - Fixing index 2
>           
> ---------
> 
> - recovering (with sort) MyISAM-table 'mysql/func.MYI'
> Data records: 0
> - Fixing index 1
>           
> ---------
> 
> - recovering (with sort) MyISAM-table 'mysql/host.MYI'
> Data records: 0
> - Fixing index 1
>           
> ---------
> 
> - recovering (with sort) MyISAM-table 'mysql/tables_priv.MYI'
> Data records: 0
> - Fixing index 1
> - Fixing index 2
>           
> ---------
> 
> - recovering (with sort) MyISAM-table 'mysql/user.MYI'
> Data records: 9
> - Fixing index 1

> 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

B^(

-- 
Kevin J. Cummings
kjchome at rcn.com
cummings at kjchome.homeip.net
cummings at kjc386.framingham.ma.us
Registered Linux User #1232 (http://counter.li.org)