MAMP is a great tool for running servers locally, however, when you must export that site you have been developing locally and your database is huge, then you could have some problems with PHPMyAdmin.
IMPORT DATABASE INTO MAMP
Step One:
Open a new terminal window
CAREFUL: This will replace all tables in the database you specify!
Importing Large Databases Into MAMP
Robert ShellApril 08, 2015
MAMP is a great tool for running servers locally, however, when you must export that site you have been developing locally and your database is huge, then you could have some problems with PHPMyAdmin.
IMPORT DATABASE INTO MAMP
Step One:
Step Two:
/applications/MAMP/library/bin/mysql -u [USERNAME] -p [DATABASE_NAME] < [PATH_TO_SQL_FILE]
/applications/MAMP/library/bin/mysql -u root -p wordpress_db < /Applications/MAMP/htdocs/backupDB.sql
Step Three:
Enter password:
Step Four:
http://localhost:8888/MAMP/