Import / Export Large Databases with MAMP

MAMP is great tool for fast development. Sometimes we need to download huge websites that has large database for working locally.

So need to import/export easily without phpmyadmin.

Importing

[code language=”php”]/applications/MAMP/library/bin/mysql -u root -p database_name < /import_file_path.sql[/code]

if you set password for user, it will ask to you.

Exporting

[code language=”php”]/applications/MAMP/library/bin/mysqldump -u root -p database_name > /export_location.sql[/code]