Date: 26 Mar 2011 17:41:00 -0000 From: "John Levine" <johnl@iecc.com> To: freebsd-questions@freebsd.org Cc: gandalf@shopzeus.com Subject: Re: MySQL 3 needed but how? Message-ID: <20110326174100.1617.qmail@joyce.lan> In-Reply-To: <4D8E1E4A.5000609@shopzeus.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20110326174100.1617.qmail>