On 2011-03-26 18:41, John Levine wrote:
In article<4d8e1e4a.5000...@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
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
