#!/bin/bash
#功能说明:本功能用于备份数据库
#编写日期:2017/11/09
PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:
export PATH
#数据库名,可以定义多个数据库,中间以空格隔开,如:test test1 test2
dbname='cms'
cnf='/etc/my.cnf'
#备份时间
backtime=`date +%Y%m%d`
#日志备份路径
logpath="${HOME}/Documents/mysqlLog"
#数据备份路径
datapath="${HOME}/Documents/database"
#日志记录头部
echo "备份时间为${backtime},备份数据库表 ${dbname} 开始" >> ${logpath}/mysqllog.log
#正式备份数据库
for table in $dbname; do
source=`mysqldump --defaults-extra-file=${cnf} ${table}> ${datapath}/${backtime}.sql` 2>> ${logpath}/mysqllog.log
#备份成功以下操作
if [ "$?" == 0 ];then
cd $datapath
#为节约硬盘空间,将数据库压缩
gpg --always-trust --output ${backtime}.en.sql --recipient 327FE8FEF0D426449AEA97E188AEB25D6FDD53EB --encrypt ${backtime}.sql > /dev/null
random=$RANDOM
zip -P ${random} ${backtime}.en.sql.zip ${backtime}.en.sql > /dev/null
#删除原始文件,只留压缩后文件
rm -f ${datapath}/${backtime}.en.sql
rm -f ${datapath}/${backtime}.sql
echo "ftp ***** zip password ${random} database backup-${backtime}" >> ${logpath}/mysqllog.log
echo -e "ftp ***** zip password ${random} \ndatabase backup-${backtime}"|mail -s "database backup" 1160343573@qq.com
echo "数据库表 ${dbname} 备份成功!!" >> ${logpath}/mysqllog.log
ftp -niv <<- EOF
open 192.168.1.61
user test-user 12345678
bin
put ${backtime}.en.sql.zip
bye
EOF
else
#备份失败则进行以下操作
echo "数据库表 ${dbname} 备份失败!!" >> ${logpath}/mysqllog.log
fi
done
04-13