每天一次全量备份,删除7天前的全量数据
每天一次 0 2 * * * /root/mysqlbak.sh
#!/bin/bash
. /etc/profile
user='root'
pass='123'
date=`date +%Y-%d-%m`
dir="/var/lib/mysql/backup"
mysqldump -u$user -p$pass --all-databases | gzip > ${dir}/ddgz-all-${date}.sql.gz
find $dir -mtime +7 -name "*.sql.gz" -exec rm -rf {} \;