MySql backup Linux via logrotate.d

MySql-backup-Logrotate.txt

# Create mysql backup user 
mysql -u root -pRootPassword
GRANT LOCK TABLES, SELECT ON *.* TO 'backupuser'@'localhost' IDENTIFIED BY 'secret-password’;

# Create log rotate script
sudo nano mysql-db-backup

/var/backups/db.sql.gz {
daily
rotate 8
nocompress
create 640 root adm
postrotate
mysqldump -u backupuser -psecret-password --all-databases > /var/backups/db.sql --single-transaction
gzip -9f /var/backups/db.sql
endscript
}

# Copy logrotate script to /etc/logrotate.d/
sudo cp mysql-db-backup /etc/logrotate.d/

# Test script
sudo logrotate -f /etc/logrotate.d/mysql-db-backup