Loading [MathJax]/jax/element/mml/optable/BasicLatin.js

mysql数据库备份脚本

#!/bin/bash

source /etc/profile

USER=ops
PASSWORD="aaaaaaaa"
#DATABASE="test tes1t"
HOSTNAME="192.168.11.11"

BACKUP_DIR=/opt/backup/mysql_back/
#LOGFILE=/opt/backup/mysql_back/data_backup.log
LOGFILE=/root/shell/logs/mysql_backup.log
DATE=`date '+%Y%m%d-%H%M'`
#DUMPFILE=DATE.i.sql
#ARCHIVE=DATE.i.sql.tgz
OPTIONS="-hHOSTNAMEuUSER -pPASSWORDsingletransactiondatabasesDATABASE"


if [ ! -d BACKUP_DIR ] ; then mkdir -p "BACKUP_DIR"
fi

echo " " >> LOGFILE echo " " >> LOGFILE
echo "———————————————–" >> LOGFILE echo "BACKUP DATE:" (date +"%y-%m-%d %H:%M:%S") >> LOGFILE echo "———————————————– " >> LOGFILE

cd BACKUP_DIR #mysqldump OPTIONS > $DUMPFILE

#for i in aaa bbb
for i in aaa
do
DUMPFILE=DATE.i.sql
ARCHIVE=DATE.i.sql.tgz

echo "begin backup {i}" mysqldump -h{HOSTNAME} -u{USER} -p{PASSWORD} --single-transaction --databases i > DATE.i.sql if [[ ? == 0 ]]; then
tar czvf ARCHIVE DUMPFILE >> LOGFILE 2>&1 echo “[ARCHIVE] Backup Successful!” >> LOGFILE rsync -auv ARCHIVE root@192.168.2.202:/data2/senses/HOSTNAME/mysql_back/ 2>&1 > /dev/null echo “[ARCHIVE] rsync 2.202 Successful!” >> LOGFILE #rm -rf DUMPFILE
#rm -fr ARCHIVE find /opt/backup/mysql_back/ -mtime +7 -exec rm -fr {} \; else echo “Database Backup Fail!” >> LOGFILE
fi
echo “${i} Backup Process Done”


done

posted @   GaoYanbing  阅读(161)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示