source: https://timmyomahony.com/blog/MAMP-phpmyadmin-and-big-database-imports-errors-or-timeouts/
-
Create the database and database user phpMyAdmin as usual.
-
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