Using MySQL in Terminal
/Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot
CREATE DATABASE test_db;
show databases;
use test_db;
SET autocommit=0 ; source /Applications/MAMP/htdocs/test_db.sql ; COMMIT ;
Ref: https://www.webnots.com/how-to-import-large-mysql-database-in-mamp-using-terminal/