Date: Sat, 26 Mar 2011 20:21:08 +0100 From: Laszlo Nagy <gandalf@shopzeus.com> To: John Levine <johnl@iecc.com> Cc: freebsd-questions@freebsd.org Subject: Re: MySQL 3 needed but how? Message-ID: <4D8E3CA4.8040808@shopzeus.com> In-Reply-To: <20110326174100.1617.qmail@joyce.lan> References: <20110326174100.1617.qmail@joyce.lan>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4D8E3CA4.8040808>