Backup Daily with logrotate

0-daily-backup.md

Daily backup with logrotate

1-mysqlbackup

## sudo touch /var/backup/dbname.sql.gz
## test
## sudo logrotate -f /etc/logrotate.d/mysqlbackup
## sudo vi /etc/logrotate.d/mysqlbackup
/var/backup/dbname.sql.gz {
 daily
 rotate 7
 nocompress
 create 640 root root
 postrotate
  mysqldump -u dbuser dbname |gzip > /var/backup/dbname.sql.gz
  echo "Backup at `date`" > /var/backup/dbname.log
 endscript
}