From owner-freebsd-questions@FreeBSD.ORG Sat Mar 26 19:40:56 2011 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 75BDA1065673 for ; Sat, 26 Mar 2011 19:40:56 +0000 (UTC) (envelope-from gandalf@shopzeus.com) Received: from fep28.mx.upcmail.net (fep28.mx.upcmail.net [62.179.121.48]) by mx1.freebsd.org (Postfix) with ESMTP id AE4408FC14 for ; Sat, 26 Mar 2011 19:40:55 +0000 (UTC) Received: from edge04.upcmail.net ([192.168.13.239]) by viefep12-int.chello.at (InterMail vM.8.01.02.02 201-2260-120-106-20100312) with ESMTP id <20110326192110.SACS18728.viefep12-int.chello.at@edge04.upcmail.net>; Sat, 26 Mar 2011 20:21:10 +0100 Received: from [192.168.0.100] ([89.134.255.51]) by edge04.upcmail.net with edge id PvM81g01W17Joup04vM9oF; Sat, 26 Mar 2011 20:21:10 +0100 X-SourceIP: 89.134.255.51 Message-ID: <4D8E3CA4.8040808@shopzeus.com> Date: Sat, 26 Mar 2011 20:21:08 +0100 From: Laszlo Nagy User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.14) Gecko/20110223 Thunderbird/3.1.8 MIME-Version: 1.0 To: John Levine References: <20110326174100.1617.qmail@joyce.lan> In-Reply-To: <20110326174100.1617.qmail@joyce.lan> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Cloudmark-Analysis: v=1.1 cv=tMVj8KYobzzX0EiRnC7vY2isLrCxFvdg4RrHWPZXwJ0= c=1 sm=0 a=dlutpJqdQxcA:10 a=MSV4LiBCzYEA:10 a=IkcTkHD0fZMA:10 a=QA7ub1_jAAAA:8 a=tekm_XskAAAA:8 a=xUm05R_ZplZEyiarvz8A:9 a=Eby65_X7je00ZyuwqTcA:7 a=j7uwzBEj0thsBsYU0cGurg_XicYA:4 a=QEXdDO2ut3YA:10 a=C2YwM-JBH08A:10 a=LII6xPS85XQA:10 a=HpAAvcLHHh0Zw7uRqdWCyQ==:117 Cc: freebsd-questions@freebsd.org Subject: Re: MySQL 3 needed but how? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 26 Mar 2011 19:40:56 -0000 On 2011-03-26 18:41, John Levine wrote: > In article<4D8E1E4A.5000609@shopzeus.com> you write: >> Hi, >> >> I have an old backup from a MySQL data directory. It was created with >> MySQL version 3. If I install MySQL 4 then I get this message telling >> that the table was created with a different MySQL version. > You should be able to restore the individual database directories > under mysql 4 and use ALTER TABLE to upgrade the file formats. You'll > lose the user access stuff, but that's usually easy enough to > reconstruct. > > In MySQL, each database is self-describing. That is, for database > foo, the files in the foo/ directory are both the description of > the tables and the data in them. > > http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html Okay, I tried to follow the instruction. So instead of installing 4.1, I have installed 4.0. After replacing /var/db/mysql with my archived directory: gw# /usr/local/etc/rc.d/mysql-server start Starting mysql. gw# /usr/local/etc/rc.d/mysql-server status mysql is not running. gw# There is nothing in /var/log/messages. It was working with 4.1 server, but I just uninstalled that (because the upgrading faq told me to install 4.0 instead.) So what now? L