Date: Thu, 11 Jun 2009 21:28:18 -0400 From: Randy Bush <randy@psg.com> To: Mel Flynn <mel.flynn+fbsd.ports@mailing.thruhere.net> Cc: freebsd-ports@freebsd.org Subject: Re: mysql 4->5 problem Message-ID: <m23aa69r65.wl%randy@psg.com> In-Reply-To: <200906111104.27039.mel.flynn%2Bfbsd.ports@mailing.thruhere.net> References: <m27hzpn35o.wl%randy@psg.com> <200906111104.27039.mel.flynn%2Bfbsd.ports@mailing.thruhere.net>
next in thread | previous in thread | raw e-mail | index | archive | help
Mel Flynn <mel.flynn+fbsd.ports@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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?m23aa69r65.wl%randy>