Mysql dump and restore database

To dump and restore all database of mysql server use following command

mysqldump -u root -psecret --all-databases > /var/www/backup.sql
mysql -u root -psecret < /var/www/backup.sql