mysql 4->5 problem

Randy Bush randy at psg.com
Sat Jun 6 09:05:09 UTC 2009


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


More information about the freebsd-ports mailing list