backup-mysql-with-logrotate.sh

# TODO use a dedicated backup user, protect gzip file with password etc
echo "/var/backups/all-databases.sql.gz {
daily
rotate 8
nocompress
create 640 root adm
postrotate
mysqldump -uroot --all-databases > /var/backups/all-databases.sql --single-transaction
gzip -9f /var/backups/all-databases.sql.sql
endscript
}" > /etc/logrotate.d/mysql-all-databases

touch /var/backups/all-databases.sql.gz

logrotate -f /etc/logrotate.d/mysql-all-databases