mysql 4->5 problem
mel.flynn+fbsd.ports at mailing.thruhere.net
Thu Jun 11 19:04:30 UTC 2009
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
> which says fix is in 5.1.35.
> i hack up some patches, except do not have the files
> 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?
More information about the freebsd-ports