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

/applications/MAMP/library/bin/mysql -u root -p database_name < /import_file_path.sql

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

 

Exporting

/applications/MAMP/library/bin/mysqldump -u root -p database_name > /export_location.sql

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s