When having a large database, the best option to export or import it would be by use the terminal.
Open the terminal and navigate to the bin directory by entering this command
Next, right the command to export your local database:
./mysqldump -u marteta -p mage_database > /Users/marteta/Desktop/new_database.sql
In order to get this path: /Users/marteta/Desktop/new_database.sql, you can drag and drop the file directly into the terminal.
Next, enter your database password and hit enter and you’re done!