From owner-freebsd-ports@FreeBSD.ORG  Sat Jun  6 09:05:08 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 CB50810656AE
	for <freebsd-ports@freebsd.org>; Sat,  6 Jun 2009 09:05:08 +0000 (UTC)
	(envelope-from randy@psg.com)
Received: from ran.psg.com (ran.psg.com [IPv6:2001:418:1::36])
	by mx1.freebsd.org (Postfix) with ESMTP id A959E8FC15
	for <freebsd-ports@freebsd.org>; Sat,  6 Jun 2009 09:05:08 +0000 (UTC)
	(envelope-from randy@psg.com)
Received: from localhost ([127.0.0.1] helo=rmac.psg.com)
	by ran.psg.com with esmtp (Exim 4.69 (FreeBSD))
	(envelope-from <randy@psg.com>) id 1MCrps-0006Sj-3c
	for freebsd-ports@freebsd.org; Sat, 06 Jun 2009 09:05:08 +0000
Received: from rmac.local.psg.com (localhost [127.0.0.1])
	by rmac.psg.com (Postfix) with ESMTP id 930A41F4C5D2
	for <freebsd-ports@freebsd.org>; Sat,  6 Jun 2009 18:05:07 +0900 (JST)
Date: Sat, 06 Jun 2009 18:05:07 +0900
Message-ID: <m27hzpn35o.wl%randy@psg.com>
From: Randy Bush <randy@psg.com>
To: FreeBSD Ports <freebsd-ports@freebsd.org>
User-Agent: Wanderlust/2.15.5 (Almost Unreal) SEMI/1.14.6 (Maruoka)
	FLIM/1.14.9 (=?ISO-8859-4?Q?Goj=F2?=) APEL/10.7 Emacs/22.3
	(i386-apple-darwin9.6.0) MULE/5.0 (SAKAKI)
MIME-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka")
Content-Type: text/plain; charset=US-ASCII
Subject: 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: Sat, 06 Jun 2009 09:05:09 -0000

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