backups

Pipe the mysqldump into

bzip2 -c > database.sql.bz2


Set up rotation with:

{code:none}
/var/backups/mysql/dump.sql {
daily
rotate 14
missingok
compress
postrotate
/usr/bin/mysqldump --defaults-extra-file=/.../backup-credentials.cnf --opt --flush-logs --all-databases > /var/backups/mysql/dump.sql
endscript
}
{code}


Comments