On Saturday 06 June 2009 01:05:07 Randy Bush wrote: > going from mysql 4 to 5.1.34. server will not start. diag is > > 090606 8:56:28 [ERROR] Fatal error: Can't open and lock privilege tables: > Incorrect key file for table 'host'; try to repair it 090606 08:56:28 > mysqld_safe mysqld from pid file /var/db/mysql/psg.com.pid ended > > googling around gets me to > > http://www.issociate.de/board/post/495472/SOLVED!_(was:_RE:_Error_:_Incorre >ct_key_file_for_table_%27X%27).html to > http://bugs.mysql.com/bug.php?id=37631 > to > http://lists.mysql.com/commits/73145 > > which says fix is in 5.1.35. > > i hack up some patches, except do not have the files > mysql-test/std_data/bug37631.MYD > mysql-test/std_data/bug37631.frm > > i rebuild. no fix. > > and, the error is after a "you can not go back" message. oh goodie. > (yes, i have backups). > > any clues out there?
You ran mysql_upgrade before starting the new server? -- Mel _______________________________________________ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"
