How to import a MAMP mysql database (bypassing phpmyadmin problems)
Recently I’ve being have a problem importing a large database in MAMP Mysql via phpmyadmin (and after altering various php variables in php.ini, I still couldn’t get it to import).
So I tried another approach to import it from the command line a quick google turned up this post on the MAMP site which got me started.
I managed to import the database fine from the command line like this:
sudo /Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot your_database_name < your_sql_import_file.sql
it might warn you about password being insecure via the command line.
I hope you find this helpful to overcome problems importing MAMP mysql databases using Phpmyadmin ( simply by using the command line).