Menu
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
436
Move the default data directory Then, find the MySQL install directory in /usr/local/Cellar and go into the subdirectory of its latest minor update. Update both references to /usr/local/var/mysql to a unique directory, For example, /usr/local/var/mysql57 .
Locate the “mysqldump file inside MAMP. It is usually located in /Applications/MAMP/Library/bin/mysqldump.
Upgrading MySQL with MySQL Installer To perform an upgrade using MySQL Installer: Start MySQL Installer. From the dashboard, click Catalog to download the latest changes to the catalog. The installed server can be upgraded only if the dashboard displays an arrow next to the version number of the server.
Go to edit-Preference-administration- (careful here. go to mysql dump.exe that is found in xampp folder not mysql folder.) example of path should be like C:\xampp\mysql\bin\mysqldump.exe. copy the path and paste in . path to mysqldump Tool.
Look at the mysql installation folder. Most likely it is /usr/local/mysql/bin You will find the mysqldump compatible to your mysql version. You need to tell mysqlworkbench to go and fetch mysqlworkbench from this location. To do that, open mysqlworkbench - preferences - admin
86
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
