I have to add something I forgot in the last comment. As mentioned in the hint itself after the succesfull install I moved my data directory to a different location, in my case /Library/mySQL/data (this is because I do a daily backup of the /Library Folder, but not the system folders).

I guess this would eleminate the problems with loosing the database after an upgrade as described by derekhed in a previous comment. This would even work without the described launchd method, as long as you keep a /etc/my.cnf file, with the appropriate datadir option, since the pkg installer won't overwrite this file.

In general I would advise to move the data folder out of the /usr/local/mysql*/ directory, this is not a good database location in general and especially on OS X. The whole directory structure of OS X is not layed out for this. I oriented my choice on the location of the apache documents folder, which is also located inside the /Library folder.




[ Reply to This | # ]