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