From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.50) id 1ESarL-0007OB-Tn for garchives@archives.gentoo.org; Thu, 20 Oct 2005 13:53:32 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id j9KDmkST018340; Thu, 20 Oct 2005 13:48:46 GMT Received: from w00p.dk (w00p.dk [80.164.34.74]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id j9KDmioZ024318 for ; Thu, 20 Oct 2005 13:48:45 GMT Received: from [172.16.10.41] (Devil.w00p.dk [172.16.10.41]) by w00p.dk (Postfix) with ESMTP id 9198F138011 for ; Thu, 20 Oct 2005 15:51:14 +0200 (CEST) Message-ID: <4357A09F.4080507@w00p.dk> Date: Thu, 20 Oct 2005 15:50:23 +0200 From: Dark User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-server@gentoo.org Reply-to: gentoo-server@lists.gentoo.org MIME-Version: 1.0 To: gentoo-server@lists.gentoo.org Subject: Re: [gentoo-server] mysql-4.1 References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archives-Salt: f7fe77ee-fc81-4547-b214-8a7f1cbe5190 X-Archives-Hash: 571d2842f1655eee599a2784645403cf Hey list, I too had problems with a single database that didn't restore correct.. A rather large one (a few mb's) that was in a single line in the backupfile that was suggested in the guide. After I removed that line from the guide, the databases restored correctly and I had no other problems upgrading mysqld. So now I'm running two mysqld's - one for the db that didn't restore, and one for all the others. Just untill I , or someone else , find out how to do this so it works. Just my .02, /Jakob Rosenlund Covington, Chris wrote: >>all you need to do is the follow step by step what's written >>here : http://www.gentoo.org/doc/en/mysql-upgrading.xml >> >> > >I followed that and I wasn't able to restore my backup. Specifically, >the snort database was screwed up: > >frank2k3 ccovington # cat BACKUP_MYSQL_4.0.SQL | mysql -uroot >-hlocalhost --max_allowed_packet=16M >ERROR 1005 (HY000) at line 1813: Can't create table './snort/data.frm' >(errno: 150) > >So I'm still using 4.0.25 > > >--- >Chris Covington >IT >Plus One Health Management >75 Maiden Lane Suite 801 >NY, NY 10038 >646-312-6269 >http://www.plusoneactive.com > > > -- gentoo-server@gentoo.org mailing list