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]

 

 

Leave a comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: