mysql 4->5 problem

[Randy Bush]

Mel Flynn <mel.flynn+fbsd.ports at 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