macOS

EXPORT DATABASE FROM MAMP

Step One:

• Open a new terminal window

Step Two:

• Navigate to the MAMP install by entering the following line in terminal
• cd /applications/MAMP/library/bin
• Hit the enter key

Step Three:

Here command changes your database according to your project and imports a large database very smoothly using the below command.

/applications/MAMP/library/bin/mysql -u root -p example_db < /Applications/MAMP/htdocs/example_db.mysql

After Run above command, you have to just add the PHPMyAdmin password if you set otherwise press enter. wait for a while for the import process.