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.
1 |
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.
1 |
CREATE DATABASE newdatabase; |
Then log out of the MySQL shell and type the following on the command line:
1 |
mysql -u [username] -p newdatabase < [database name].sql |
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.
I am Arjun from Hyderabad (India). I have been working as a software engineer from the last 7+ years, and it is my passion to learn new things and implement them as a practice. Aside from work, I like gardening and spending time with pets.