撰写并执行 MySQL 5.6 的 backup 脚本，同时发出 email

发布时间：2023-07-31 15:11:16 所属栏目：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

#defin

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" qujian@joyveb.com

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}

（编辑：聊城站长网）

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