On 05/20/2010 02:11 AM, Sam Sharpe wrote: > On 20 May 2010 05:24, Kevin J. Cummings <cummings@xxxxxxxxxxxxxxxxxx> 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@xxxxxxx cummings@xxxxxxxxxxxxxxxxxx cummings@xxxxxxxxxxxxxxxxxxxxxxx Registered Linux User #1232 (http://counter.li.org) -- users mailing list users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
