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.