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.
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.
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.