/var/backups/mysqldump.sql {
daily
rotate 7
missingok
compress
postrotate
/usr/bin/mysqldump --user=root --password=REDACTED --flush-logs --all-databases > /var/backups/mysqldump.sql
endscript
}