1 Reply Latest reply: Aug 6, 2008 8:54 PM by Paul Vail
Alan Sill Level 1 Level 1 (0 points)
I have an old mysql 4 database from a previous installation that I need to bring up temporarily to access and dump the tables. I have all of the /var/mysql stuff from the old backup, but if I temporarily move the Leopard directory of that name out of the way and try to bring it up in MySQL 5 under 10.5 server, it starts, but the upgrade steps seem too hard to complete to migrate the tables in the database up to MySQL5 standards.

I would like to just bring the old database up under MySQL 4 and move what I need out via a dump or other tools. How can I start MySQL 4 instead of 5 within Leopard? I see that there is actually a /usr/local/mysql-standard-4.0.25-apple-darwin7.9.0-powerpc in place already within Leopard Server; how can I make it start rather than the MySQL 5 that comes up when I start MySQL within Server Admin?

XServe dual-G5, Mac OS X (10.5.4), OS X Server
  • 1. Re: Temporarily downgrade MySQL to version 4 to retrieve old contents
    Paul Vail Level 1 Level 1 (135 points)
    You would be better off getting a spare hard drive (firewire), installing the old install on that, boot up on the spare drive, move your mySQL 4 to that drive, retrieving the data off, then reboot back to your normal server.

    This allows you to experiment without risking your server, assuming that is a production machine that can't be buggered up without folks getting riled.