Unless you have a backup of your mysql data directory or have .sql dumps (you do, don't you?), you are pretty well hosed.

Upgrading mysql using MySQL's pkg installers has been a nightmare. You usually have to trash the receipt out of /Library/Receipts (this will fix your problem of not being able to install/upgrade) before running the new package. Sometimes it works fine, other times all your databases go missing after the upgrade is done.

I generally don't upgrade MySQL on a Mac once I've got it running, unless there is a glaring security hole or some great new feature. If I do plan to upgrade though, first step is to get .sql dumps of all my databases. Once the server has been upgraded (and if my databses are missing), I then run the .sql dumps and am back in business.

[ Reply to This | # ]

I had a ~30 hour old complete SQL dump so I was able to quickly get back online after removing all traces of the new installation and then installing the older version again. Lost some data though. The .MYI files all disappeared during the installation project.

Well I guess that is what you get for not having a fresh backup when installing new versions.

---
Life only demands from you the strength you possess. Only one feat is possible - not to have run away.

[ Reply to This | # ]