Backup and Restore Databases in MySQL

Just simple as following:

mysqldump -h host -u user -p –databases db > dbbackup

mysqldump -h host -u user -p

CREATE DATABASE restored;

mysql -h host -p -u user restored < dbbackup