Mel Flynn <mel.flynn+fbsd.po...@mailing.thruhere.net> wrote: > > 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?
mysql_upgrade requires a running server i ended up just o blowing /var/mysql/* away o starting new server o restoring from backup randy _______________________________________________ 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"