MySQL Backup

Simple backup of entire mysql Database

mysqldump -u root -p --single-transaction --all-databases > backup.sql

and to restore

mysql -u root -p < backup.sql

Thats it..Quick and easy