Mysql Dump Rotation

mysql-dump

/path/to/dumps/*.sql {
	daily
	rotate 14
	missingok
	create 660 andrey andrey
	compress
	sharedscripts
	postrotate
		USER="dbuser"
		PASSWORD="dbpassword"
		OUTPUT="/path/to/dumps"
		databases=`mysql --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database | grep -v _schema`
		for db in $databases; do
			mysqldump --user=$USER --password=$PASSWORD $db > $OUTPUT/$db.sql
		done
		mysqldump --user=$USER --password=$PASSWORD --all-databases > $OUTPUT/all.sql --single-transaction
	endscript
}

run-this-code-to-initialize

touch /path/to/dumps/empty.sql