From owner-freebsd-ports@FreeBSD.ORG  Fri Jun 12 01:28:21 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 A8472106566B
	for <freebsd-ports@freebsd.org>; Fri, 12 Jun 2009 01:28:21 +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 80A928FC1A
	for <freebsd-ports@freebsd.org>; Fri, 12 Jun 2009 01:28:21 +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 1MEvZ6-000Na0-5B; Fri, 12 Jun 2009 01:28:20 +0000
Received: from rmac.local.psg.com (localhost [127.0.0.1])
	by rmac.psg.com (Postfix) with ESMTP id A2B9D213BB8D;
	Thu, 11 Jun 2009 21:28:19 -0400 (EDT)
Date: Thu, 11 Jun 2009 21:28:18 -0400
Message-ID: <m23aa69r65.wl%randy@psg.com>
From: Randy Bush <randy@psg.com>
To: Mel Flynn <mel.flynn+fbsd.ports@mailing.thruhere.net>
In-Reply-To: <200906111104.27039.mel.flynn+fbsd.ports@mailing.thruhere.net>
References: <m27hzpn35o.wl%randy@psg.com>
	<200906111104.27039.mel.flynn+fbsd.ports@mailing.thruhere.net>
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
Cc: freebsd-ports@freebsd.org
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: Fri, 12 Jun 2009 01:28:21 -0000



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