Add mysqldump to MAMP (MySQL /w Apache PHP on MacOS X)

Question

I wonder how I can add mysqldump to my MAMP environment. I googled a bit and found only the community MySQL server version. But I do not want to install another MySQL – basically because I want to save my data first, before any experiment.

Answer 1

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.

Answer 2

In .bash_profile, add PATH="$PATH:/Applications/MAMP/Library/bin".

If you don't have a .bash_profile, you can create one.

Answer 3

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