mysql5.6备份脚本并发送邮件

发布时间：2023-05-06 12:54:37 所属栏目：MySql教程来源：

导读：mysql5.6备份脚本并发送邮件

1.全库备：
#!/bin/bash
#name: full library backup

#backup directory
back_Dir=date +%Y-%m-%d
#create backup direct
mkdir /opt/$back_Dir
#deFinition backup path
b

mysql5.6备份脚本并发送邮件

1.全库备：
#!/bin/bash
#name: full library backup

#backup directory
back_Dir=date +%Y-%m-%d
#create backup direct
mkdir /opt/$back_Dir
#deFinition backup path
back_path=/opt/$back_Dir
#deFinition backup command
command=which mysqldump

emailFile='/tmp/email.txt'
echo "" > $emailFile
echo $(date +%Y-%m-%d' '%H:%M:%s) >> $emailFile

#backup DCOM library
$command --login-path=backtest --add-locks -q DCOM > $back_path/$back_Dir.sql

if [[ $? == 0 ]];then
echo $(du -h $back_path/$back_Dir.sql) >> $emailFile
echo "DataBase DCOM Backup Success!!" >> $emailFile
fi

cat $emailFile | mail -s "MysqL Backup"
rm -rf $emailFile

2.备份有数据的表（只是备份数据不包含表结构）
#!/bin/bash
path=/opt/sql
dir=mkdir $path/$(date +%Y-%m-%d)
dir1=$(date +%Y-%m-%d)
MysqL --login-path=backtest -e "show tables from DCOM" > $path/$dir1/tables.txt

for i in cat $path/$dir1/tables.txt
do
number=MysqL --login-path=backtest -e "select count(*) from DCOM.$i" | tail -1
if [ $number -gt 0 ]
then echo "$i" >> $path/$dir1/datanum.txt
else echo "$i" >> $path/$dir1/nodatanum.txt
fi
done

for tables in cat $path/$dir1/datanum.txt
do
MysqLdump --login-path=backtest --add-locks -q -t DCOM $tables > $path/$dir1/$tables.sql
done

rm -f $path/$dir1/{datanum.txt,nodatanum.txt,tables.txt}

（编辑：汽车网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!