linux 下备份MySQL数据库 并删除7天前的备份数据

#!/bin/bash#备份数据库hz jshuabo sdhuaboname=$(date +%Y%m%d)/alidata/server/mysql-5.1.73/bin/mysqldump -u root -p123456 hz > /root/sqlBackup/hz.$name.sql/alidata/server/mysql-5.1.73/bin/mysqldump -u root -p123456 jshuabo > /root/sqlBackup/jshuabo.$name.sql/alidata/server/mysql-5.1.73/bin/mysqldump -u root -p123456 sdhuabo > /root/sqlBackup/sdhuabo.$name.sql#删除一周之前的备份文件file_path="/root/sqlBackup"#方法a#rm -rf `find $file_path '*.sql' -mitime 7 -print` > delete.log;#方法bfind $file_path -mtime +7 -type f|xargs rm -f#方法c#rm -f `find $file_path -mtime +7 -type f`