数据库备份脚本(保留近7天数据)

backupdir=/data/mysql_backup
time=` date +%Y_%m_%d_%H_%M_%S `
db_host=127.0.0.1
db_user=qa
db_pass=qa123
mysqldump --host=$db_host -u $db_user -p$db_pass --databases dealertest > $backupdir/$time.sql
find $backupdir -name "*.sql" -type f -mtime +7 -exec rm -rf {} \; > /dev/null 2>&1