Import Database into MAMP PRO using terminal

howto.md

source: https://timmyomahony.com/blog/MAMP-phpmyadmin-and-big-database-imports-errors-or-timeouts/

IMPORT DATABASE INTO MAMP

1. Create the database and database user phpMyAdmin as usual.

2. Connect to mysql by running the following command from the directory where the dump file was stored:

   /Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot

3. Run the following from the mysql commandline: (replace “mydatabase” with the name of the database you created in step 1 or that was already in your dump and replace “myfile.sql” with the name of your file):

   mysql> use mydatabase;

   mysql> source myfile.sql;