I'm using MySql server on Mac OSX 10.6.7, and I've installed latest version of MySQL Workbench GUI to administrate it. When I try to Export a database, I get a message about mysqldump being version 5.1.34 and therefore incompatible with the server whose version is 5.5.9. How can I update the mysqldump version to be compatible with my server? Thanks
Your best bet is to trash what ever mysql server u have installed, and install it via Brew
You can also just install mysql from in addition to the one you are running however this isnt advised.
brew install mysql
hopefully the brew version will be new enough to support it.
Before dumping your old mysql install however, it might be a good idea to do an export via a tool like navicat.