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

Question

Hi all,

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.

thx for help in advance (probably it´s just a simple link :)

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 the 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.