Multimple MySQL DB Backup To .sql file and Restore

Backup

If you want to backup a single MySQL DB then use

mysqldump database_name > database_name.sql

If you want to use this for multiple DB's then

mysqldump --databases database_one database_two > two_databases.sql

 For all DB

mysqldump --all-databases > all_databases.sql

Restore

Restore one DB

 mysql database_name < database_name.sql

Restore multiple DB

mysql --one-database database_name < all_databases.sql