MYSQL备份脚本
5墨值下载
资源由 www.eimhe.com 美河学习在线收集分享
MYSQL
备份脚本
#!/bin/bash
#by coco wu
#2012-09-26
DATE=`date "+%Y%m%d"`
IP="localhost"
DB_NAME="heimdall db1 verification"
DB_USER="root"
DB_PASS="qkJRrICHcDO1T1qGyWvr"
BIN_DIR="/usr/local/mysql/bin"
BAK_DIR="/data/dbbk/local"
BAK_PATH=$BAK_DIR/$DATE
REMOTE_IP=192.168.21.243
REMOTE_PATH=/data/dbbk/192.168.21.3
FILE_MY_CNF=/etc/my.cnf
FILE_MYSQLD=/etc/rc.d/init.d/mysqld
#echo "come here"
if [ ! -d $BAK_PATH ] ; then
mkdir -p $BAK_PATH
fi
cp -a $FILE_MY_CNF $BAK_PATH
cp -a $FILE_MYSQLD $BAK_PATH
variables="`$BIN_DIR/mysql -u$DB_USER -p$DB_PASS -h$IP -e "show create database
mysql;" |awk '{print $9}' |sed -n '2'p`"
if $BIN_DIR/mysqldump --opt --single-transaction --default-character-set=$variables -h$IP
-u$DB_USER -p$DB_PASS mysql user | gzip > $BAK_PATH/mysql_user-$DATE.sql.gz ; then
echo -e "\033[32m $DATE mysql.user backup success...\033[0m" >>$BAK_DIR/backup-log.txt
else
echo -e "\033[31;5m $DATE mysql.user backup false...\033[0m" >>$BAK_DIR/backup-log.txt
fi
for db_name in $DB_NAME
do
# echo -e "\033[32m$variables...\033[0m" >> $BAK_DIR/backup-sucess.txt
variables="`$BIN_DIR/mysql -u$DB_USER -p$DB_PASS -h$IP -e "show create database
$db_name;" |awk '{print $9}' |sed -n '2'p`"
echo $db_name$variables
# variables="utf8"
# if $BIN_DIR/mysqldump --opt --single-transaction --default-character-set=$variables -h$IP
-u$DB_USER -p$DB_PASS -R --hex-blob --flush-logs --databases $db_name | gzip >
$BAK_PATH/$db_name-$DATE.sql.gz ; then
资源由 www.eimhe.com 美河学习在线收集分享
# echo -e "\033[32m $DATE $db_name backup success...\033[0m" >>$BAK_DIR/backup-
log.txt
# else
# echo -e "\033[31;5m $DATE $db_name backup false...\033[0m" >>$BAK_DIR/backup-
log.txt
# fi
done
exit 0
scp -r -P 58499 $BAK_PATH root@$REMOTE_IP:$REMOTE_PATH
#scp -r -p $BAK_PATH root@192.168.21.243:/data/dbbk/192.168.21.3
find $BAK_DIR -name "*" -mtime +4 |xargs rm -rf
find $BAK_DIR -type d -empty |xargs rm -rf
exit 0
of 2
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论