Date: Sat, 06 Jun 2009 18:05:07 +0900 From: Randy Bush <randy@psg.com> To: FreeBSD Ports <freebsd-ports@freebsd.org> Subject: mysql 4->5 problem Message-ID: <m27hzpn35o.wl%randy@psg.com>
next in thread | raw e-mail | index | archive | help
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_:_Incorrect_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?
randy
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?m27hzpn35o.wl%randy>