On 20 May 2010 07:26, Kevin J. Cummings <cummings@xxxxxxxxxxxxxxxxxx> wrote: > 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/ >> 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 -- 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
