On Mar 25, 2008, at 13:27, Chris Janton wrote:

I a merely an egg.

I have mysql5 installed and working just fine

port install mysql5 +server

I am curious about how I would go about installing, using, and/or switching back and forth if I did

port install mysql5-devel

Do I need to deactivate/stop mysql5 first?

Inquiring minds want to know.

If you have done: sudo port install mysql5-devel +server Then, to switch from mysql5 to mysql5-devel, do this: sudo launchctl unload -w /Library/LaunchDaemons/ org.macports.mysql5.plist sudo port deactivate mysql5 sudo port activate mysql5-devel sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5- devel.plist

On Mar 26, 2008, at 6:38 AM, Chris Janton wrote:

Thank you. That worked nicely.

Now I have to figure out why "mysql_upgrade" doesn't work at all...

face@mac:~:125 $ mysql_upgrade5 Looking for 'mysql' in: mysql FATAL ERROR: Can't find 'mysql'

8)

Hi Chris, The layout and naming of the mysql5 on macports is quite wacky, due to a probably misguided effort to allow the mysql 4 and 4 ports in coexist. The msyql_upgrade5 script (and probably others) suffer from this, and fail to work correclty. I think the macports community would be better served by going to a more standard mysql installation layout and naming policy for mysql 5, and abandoning the wacky naming scheme. (I've worked on various pieces of this over the years, and have come to this conclusion after banging my head repeatedly against this wall). James