Last updated on January 25, 2021
Export Database
To export a database, open up the terminal, making sure that you are not logged into MySQL, and execute the below command with database details.
mysqldump -u [username] -p [database_name] > [database_name].sql
The selected database in the command will be exported to your machine.
Import Database
To import a database, first, create a new blank database with the below command. First, you have to log in to the MySQL database before executing the create database command.
CREATE DATABASE newdatabase;
Then log out of the MySQL shell and type the following on the command line:
mysql -u [username] -p newdatabase < [database name].sql
With that, your chosen database has been imported into your destination database in MySQL.