MYSQL Import and export database through command line

Update environment variable path upto mysql bin

e.g. C:\Program Files\MySQL\MySQL Server 5.7\bin



Check whether mysql path set up correctly just execute mysql command




Go to command line 

Fire below command to export db
mysqldump -u root -p mydb > exportedmydb.sql


Fire below command to import db
mysqldump -u root -p importeddb < exportedmydb.sql

It will ask password once you execute command provide mysql password.