mysql 4->5 problem

[Mel Flynn]

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