Upgrading MySQL 5.5.x using the binary package is a bit more difficult than the source based upgrade, but is still do-able. The biggest issue will be the longer downtime. You need to stop the database from running while you are running the installer.

First step is to create a backup of your databases! Something might go wrong and you could loose all your data.

To upgrade your current MySQL installation you download the latest binary package of MySQL. First stop your current installation before you continue. Then open the .dmg file and run the package installer. Now comes the hardest part as you need to copy your databases from the old directory to the new installation directory. Use the following commands as an example and please use the correct version numbers.

cd /usr/local
sudo cp -R mysql-5.5.8-osx10.6-x86/data/ mysql-5.5.9-osx10.6-x86/data/
sudo chown -R _mysql mysql-5.5.9-osx10.6-x86/data

To make sure that all the programs compile correct you’ll need to execute the following command, when you’ve finished the installation, in the Terminal:

sudo install_name_tool -id /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/local/mysql/lib/libmysqlclient.dylib

Then startup MySQL again and check if everything is running properly. If it is then you are done.