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