MySQL Backup

To create a compressed backup of your MySQL Database you can use the following statement:

mysqldump --all-databases -u user -p'password' | gzip > /path/file-"`date +%F-%H-%M-%S`
".sql.gz