Backup

mysqldump -u user_name -p[your_password] database_name > File_name.sql

This will only work if the database does not already exist:

mysql - u user_name -p your_password database_name < file_name.sql

Or using our example from the previous page:

If your database already exists and you are just restoring it, try this line instead:

mysqlimport -u user_name -p[your_password] database_name file_name.sql

Backup and Restore Mysql 

SQL