备份数据库的同时删除7天以前备份的数据,减轻服务器压力
#!/bin/bash
source /etc/profile
data=`date +%F_%H-%M-%S`
password="****"
DBNAME="****"
BACKUPFILE=/backup_path/
/usr/bin/mysqldump -uroot -p${password} --single-transaction --triggers --routines ${DBNAME} > ${ BACKUPFILE}${DBNAME}_${data}.sql
find ${BACKUPFILE} -name "*.sql" -type f -mtime +7 | xargs rm -rf