13518219792
1.全库备：
#!/bin/bash
#name: full library backup
创新互联公司基于成都重庆香港及美国等地区分布式IDC机房数据中心构建的电信大带宽，联通大带宽，移动大带宽，多线BGP大带宽租用,是为众多客户提供专业服务器托管报价，主机托管价格性价比高，为金融证券行业中国电信云锦天府，ai人工智能服务器托管提供bgp线路100M独享，G口带宽及机柜租用的专业成都idc公司。
#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}
