Add mysqldump to MAMP (MySQL /w Apache PHP on MacOS X)
This will helps you to resolve:
- In your home directory create or edit the file
.bash_profile
you can access your home directory by typing:cd ~/
Add this to the top of the file:
export PATH=$PATH:/Applications/MAMP/Library/bin
Save the file and then restart your Terminal
- In your newly restarted Terminal window type:
mysql –version
I've recently discovered that MAMP PRO hides all your mysql terminal abilities.
Using this though copies all the mamp Mysql magic over to your local bin, where you can start using all wp-cli db functions again or anything that you need with databases via terminal:
sudo ln -s /Applications/MAMP/Library/bin/mysql /usr/local/bin/mysql;
sudo ln -s /Applications/MAMP/Library/bin/mysqlcheck /usr/local/bin/mysqlcheck;
sudo ln -s /Applications/MAMP/Library/bin/mysqldump /usr/local/bin/mysqldump
In .bash_profile
, add PATH="$PATH:/Applications/MAMP/Library/bin"
.
If you don't have a .bash_profile
, you can create one.
Found the solution on my own. Maybe this helps other Mac users... In fact mysqldump ships with MAMP but is located somewhere in the desert:
/Applications/MAMP/Library/bin/mysqldump
That´s why tools like MySQL workbench do not find it, neither does it work in terminal without the path. So finally just type:
/Applications/MAMP/Library/bin/mysqldump -u yourUser -p --opt yourdb > yourdump.sql
to create a dump.