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="-hHOSTNAME−uUSER -pPASSWORD−−single−transaction−−databasesDATABASE"
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
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步