Export Import mysql DB

Using SSH, execute the following command: 

Export A MySQL Database

mysqldump -p -u username database_name > dbname.sql 
 
 
Import A MySQL Database
 

 mysql -p -u username database_name < file.sql


Note: The -p will prompt for your account's password.