dump备份mysql库
2024-09-01 01:01:05
Auth: Jin
Date: 20140403
Content:
#!/bin/bash -
### auth: Jin
### date:
### Desc: 根据配置文件里的ip,端口(dblist文件格式为192.168.201.::sso:root:passwd),数据库名dump备份mysql数据,清理指定天前的备份文件,通过ssh隧道追加同步到其他IDC服务器上
### Usage: ./dump_mysqldatabase.sh BACKDIR=/data/BackupPC/database
LIST=${BACKDIR}/dblist
BACKUPLOG=${BACKDIR}/dump_mysqldatabase.log
TODAY=`date +%F`
DELDAY=`date -d "7 day ago" +%F`
NUM=$(cat $LIST | wc -l)
DUMPBIN=/usr/local/mysql/bin/mysqldump
RSYNCBIN=/usr/bin/rsync function log ()
{
echo " " >> $BACKUPLOG
echo "###########################" >> $BACKUPLOG
echo "`date +%F/%T` $1" >> $BACKUPLOG
echo "###########################" >> $BACKUPLOG
} log START ### dump
for (( i=; i<=$NUM; i=i+ ));do
IP=$(sed -n "$i"p $LIST | awk -F : '{print $1}')
PORT=$(sed -n "$i"p $LIST | awk -F : '{print $2}')
DB=$(sed -n "$i"p $LIST | awk -F : '{print $3}')
USER=$(sed -n "$i"p $LIST | awk -F : '{print $4}')
PASSWD=$(sed -n "$i"p $LIST | awk -F : '{print $5}')
${DUMPBIN} -h${IP} -P${PORT} -u${USER} -p${PASSWD} ${DB} --opt | gzip - > ${BACKDIR}/db-${TODAY}.${DB}.sql.gz
if [ $? -eq ];then
echo "${IP} ${PORT} ${DB} backup Sucessful" >> $BACKUPLOG
else
echo "${IP} ${PORT} ${DB} backup Fail" >> $BACKUPLOG
fi
done ### delete
for (( i=; i<=$NUM; i=i+ ));do
DB=$(sed -n "$i"p $LIST | awk -F : '{print $3}')
rm -f ${BACKDIR}/db-${DELDAY}.${DB}.sql.gz
if [ -f "${BACKDIR}/db-${DELDAY}.${DB}.sql.gz" ]; then
echo "${BACKDIR}/db-${DELDAY}.${DB}.sql.gz delete Fail" >> $BACKUPLOG
else
echo "${BACKDIR}/db-${DELDAY}.${DB}.sql.gz delete OK" >> $BACKUPLOG
fi
done ### rsync to other IDC
${RSYNCBIN} -av -e"ssh" ${BACKDIR}/ root@10.1.0.22:${BACKDDIR}/
if [ $? -eq ];then
echo "JQ IDC rsync to ZJ IDC OK" >> $BACKUPLOG
else
echo "JQ IDC rsync to ZJ IDC Fail" >> $BACKUPLOG
fi log END
最新文章
- 前端面霸系列(1):doctype 、Quirks Mode &; Standards Mode 、document.compatMode
- POJ No.3617【B008】
- iOS第八课——Navigation Controller和Tab bar Controller
- 【Networking】k8s容器网络 &;&; golang相关
- 【OpenStack】OpenStack系列4之Glance详解
- Java后端开发
- HDU-4614 Vases and Flowers (线段树区间更新)
- “我爱淘”冲刺阶段Scrum站立会议1
- JS/jQuery宽高的理解和应用
- VirtualBox虚拟机安装MSDOS和MINIX2.0.0双系统
- linux 下vi中关于删除某段,某行,或者全部删除的命令
- HDOJ 4862 Jump
- 创建Win32图形界面应用程序
- PHP超全局变量$_SERVER
- Struts2 05---拦截器
- 编译装php7.2 &;&; nginx-1.14
- Confluence 6 使用电子邮件可见
- Emoji表情编解码库XXL-EMOJI
- centos6 python 安装 sqlite 解决 No module named ‘_sqlite3′
- xampp默认mysql数据库root密码的修改