Importing and Exporting MySQL database Command Line

Exporting from MySQL :

mysqldump -u mysql_username -p database_name > output_file.sql

You can put absolute or relative path of output_file.sql

Enter the database password.

Eg. : mysqldump -u root -p blueheri > blueheri.sql

Importing to MySQL :

mysql -u username -p database_name < input_file.sql

You can put absolute or relative path of input_file.sql

Enter the database password.

Eg. mysql -u root -p blueheri < blueheri.sql