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]