Data Base, SSH

How to Import a Large Magento Database in MAMP

If you have a large magento database that you can’t import through phpMyAdmin the best way to do it is by using the terminal.

The first thing you should do is to open MAMP > webstart and navigate to phpMyAdmin. Create a database (example magento_db) and make sure to assign a username and password.

Next, open your terminal and paste this command:

/applications/MAMP/library/bin/mysql -u michel_arteta -p magento_db < /Users/your_user_name/Desktop/data_base_to_import.sql

Click enter and next enter your database password.

Finally navigate to phpMyAdmin > magento_db and change in the core_config_data table the secure and unsecure URL.