From owner-freebsd-questions@FreeBSD.ORG Sat Mar 26 18:08:03 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 E1986106566B for ; Sat, 26 Mar 2011 18:08:03 +0000 (UTC) (envelope-from prvs=0059cc19d1=johnl@iecc.com) Received: from gal.iecc.com (gal.iecc.com [64.57.183.53]) by mx1.freebsd.org (Postfix) with ESMTP id 62AD08FC12 for ; Sat, 26 Mar 2011 18:08:03 +0000 (UTC) Received: (qmail 67272 invoked from network); 26 Mar 2011 17:41:22 -0000 Received: from mail1.iecc.com (64.57.183.56) by mail1.iecc.com with QMQP; 26 Mar 2011 17:41:22 -0000 Date: 26 Mar 2011 17:41:00 -0000 Message-ID: <20110326174100.1617.qmail@joyce.lan> From: "John Levine" To: freebsd-questions@freebsd.org In-Reply-To: <4D8E1E4A.5000609@shopzeus.com> Organization: X-Headerized: yes Mime-Version: 1.0 Content-type: text/plain; charset=utf-8 Content-transfer-encoding: 7bit Cc: gandalf@shopzeus.com 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 18:08:04 -0000 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 R's, John