复制#!/bin/bash #this is mysqldump auto table backup script #Copyright by hwb backup_path="/pasdata/backup" user="root" passwd="xx.xx.x.x dbname="pas_prod" host="localhost" tablename="t_att_overtime_application" today=`date +"%Y%m%d-%H%M%S"` sqlname=$tablename$today.sql if [ -e /home/scripts/log_function.sh ] then source /home/scripts/log_function.sh else echo -e “\033[41;37m /home/scripts/log_function.sh isnot exist. \033[0m” exit 1 fi backup(){ log_correct "开始执行备份脚本,据库基于删除14天过期备份" #backup mysqldump -h$host -u$user -p$passwd $dbname --tables $tablename >$backup_path/$sqlname} delete(){ #delete expired 14 days find $backup_path -mtime +14 -type f -name*.sql -exec rm -f {} ; } size(){ cd $backup_path dd=`du -sh $sqlname` if [ -s ./$sqlname ] ; then log_correct 调休表备份正常 log_correct $dd else log_error 调休表备份失败 fi } backup delete size 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44. |
喜欢
讨厌