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

#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}