How to dump/restore MySQL Databases

Export A MySQL Database:

mysqldump -u username -ppassword database_name > FILE.sql 

Import A MySQL Database:

mysql -u username -ppassword database_name < FILE.sql

Use the --all-databases option to back up all the MySQL databases:

mysqldump -u root -p --all-databases > all_databases.sql