Full Stack LAMP - MEAN Developer, Python developer. Certified Azure Developer. Freelance programmer/consultant/trainer.

How to Import and Export MySQL Databases

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.

Leave a Reply