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.

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.

Then log out of the MySQL shell and type the following on the command line:

With that, your chosen database has been imported into your destination database in MySQL.

I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
DMCA.com Protection Status
0
Would love your thoughts, please comment.x
()
x