每天定时备份所有数据库数据库名字在文件:dbfile中,定时清除3天前的备份文件
#!/bin/bash dd=`date +%Y%m%d` backup_dir="/usr/soft/crontabshell/" username="uname" password="password" for dbname in `cat ${backup_dir}dbfile` do nohup /usr/local/MysqL/bin/MysqLdump -u${username} -p${password} -B $dbname > ${backup_dir}${dbname}_${dd}.sql 2>/dev/null & ####echo $? done find $backup_dir -ctime +3 -name "*.sql" -exec rm -rf {} \; 原文链接:https://www.f2er.com/bash/389453.html