Backup & Recovery MySQL -mysqldump

Backup
mysqldump db_name > backup-file.sql

Restore
mysql db_name < backup-file.sql