Sometime we want to export large database files. Here is the best steps for creating database exportfile in MAMP.
It should be done via terminal as below.
- In the terminal navigate to
bin
folder of MAMP using below commandcd /Applications/MAMP/library/bin
- Use this command to export the file
./mysqldump -u [USERNAME] -p [DATA_BASENAME] > [PATH_TO_FILE]
. EG would be./mysqldump -u root -p my_database_name > /Applications/MAMP/htdocs/folder_name/exported_db.sql
- Line should appear saying
Enter password:
. Here enter the MySQL password. keep in mind that the letters will not appear, but they are there.