Unfortunately, you're not the think-ahead safe network admin you thought you were. You are merely human.
Fear not, human! There is still hope.
The MySQL documentation clearly states that you're data is not lost, the update process is merely incomplete. Your data is safe and sound in it's old directory. The new installation just defaults to using a newer, less content-filled database to begin with for the sole purpose of making you shit yourself.
If we cd [as root] into /usr/local/ we see two MySQL folders:
Inside the 5.0 folder, we find all the necessary files to run a MySQL server. Inside the 4.1 folder we find only the a data folder ...
So, to be safe, here's what we do:
- Shut down the mysql daemon (from system prefs if you installed the option)
- Copy the data folder in the 5.0 folder to data_bak
- Copy the data folder from the 4.1 folder to the 5.0 folder.
- You may also have to chown all the files to mysql
- cd /usr/local/mysql-5.0.45-osx10.4-powerpc
- cp -r data/ data_bak/
- cp -r ../mysql-standard-4.1.20-apple-darwin8.6.0-powerpc/data/ ./data/
- chown -R mysql data
If the system prefs thing doesn't work after a reboot ... uhh ... just get over it. Have a beer.