backup and restore mysql

Backup;

mysqldump -u [username] -p [databaseName] > [filename]-$(date +%F).sql

Restore; 

mysql -u [username] -p [databaseName] < [filename].sql

See here for more details...