From owner-freebsd-ports@FreeBSD.ORG  Thu Jun 11 19:04:29 2009
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
Delivered-To: freebsd-ports@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id BE4571065688
	for <freebsd-ports@freebsd.org>; Thu, 11 Jun 2009 19:04:29 +0000 (UTC)
	(envelope-from mel.flynn+fbsd.ports@mailing.thruhere.net)
Received: from mailhub.rachie.is-a-geek.net (rachie.is-a-geek.net
	[66.230.99.27]) by mx1.freebsd.org (Postfix) with ESMTP id 8DA958FC21
	for <freebsd-ports@freebsd.org>; Thu, 11 Jun 2009 19:04:29 +0000 (UTC)
	(envelope-from mel.flynn+fbsd.ports@mailing.thruhere.net)
Received: from smoochies.rachie.is-a-geek.net (mailhub.rachie.is-a-geek.net
	[192.168.2.11])
	by mailhub.rachie.is-a-geek.net (Postfix) with ESMTP id AA7597E843;
	Thu, 11 Jun 2009 11:04:28 -0800 (AKDT)
From: Mel Flynn <mel.flynn+fbsd.ports@mailing.thruhere.net>
To: freebsd-ports@freebsd.org
Date: Thu, 11 Jun 2009 11:04:26 -0800
User-Agent: KMail/1.11.3 (FreeBSD/8.0-CURRENT; KDE/4.2.4; i386; ; )
References: <m27hzpn35o.wl%randy@psg.com>
In-Reply-To: <m27hzpn35o.wl%randy@psg.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200906111104.27039.mel.flynn+fbsd.ports@mailing.thruhere.net>
Cc: Randy Bush <randy@psg.com>
Subject: Re: mysql 4->5 problem
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 11 Jun 2009 19:04:30 -0000

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