Data Base, SSH

How to Export a Large Data Base from MAMP

When having a large database, the best option to export or import it would be by use the terminal.

Open the terminal and navigate to the bin directory by entering this command

cd /applications/MAMP/library/bin

Next, right the command to export your local database:

./mysqldump -u marteta -p mage_database > /Users/marteta/Desktop/new_database.sql

In order to get this path: /Users/marteta/Desktop/new_database.sql, you can drag and drop the file directly into the terminal.

Next, enter your database password and hit enter and you’re done!