You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
44 lines
925 B
44 lines
925 B
1 month ago
|
# !/bin/bash
|
||
|
|
#配置
|
||
|
|
## 备份文件路径
|
||
|
|
BASEDIR=/data/mmogrun/mysql_backup
|
||
|
|
## 当前时间
|
||
|
|
CURDATE=$(date +%Y%m%d)
|
||
|
|
## 当前时间
|
||
|
|
CURDATES=$(date +%Y%m%d_%H%M%S)
|
||
|
|
#备份的数据数据库目录
|
||
|
|
BAKUPDIR=$BASEDIR/mysql_bak/$CURDATE
|
||
|
|
#临时文件目录
|
||
|
|
TMPDIR=$BASEDIR/tmp
|
||
|
|
#binlog备份目录
|
||
|
|
BINLOGBAKDIR=$BASEDIR/baklogbin
|
||
|
|
#操作日志目录
|
||
|
|
LOGDIR=$BASEDIR/log
|
||
|
|
#恢复日志
|
||
|
|
RECOVERY_LOG=$LOGDIR/recovery.log
|
||
|
|
#备份日志
|
||
|
|
BAKUP_LOG=$LOGDIR/backup.log
|
||
|
|
|
||
|
|
MYSQLBINLOG=/usr/bin/mysqlbinlog
|
||
|
|
MYSQLDUMP=/usr/bin/mysqldump
|
||
|
|
MYSQL=/usr/bin/mysql
|
||
|
|
#################可能需要修改的############################
|
||
|
|
#binlog 目录
|
||
|
|
BINLOGDIR=./data/
|
||
|
|
#mysql配置
|
||
|
|
USER=mmog
|
||
|
|
PASS=mmog
|
||
|
|
MYSQLIP=localhost
|
||
|
|
MYSQLPORT=3306
|
||
|
|
|
||
|
|
mkdir -p $TMPDIR
|
||
|
|
mkdir -p $LOGDIR
|
||
|
|
mkdir -p $BINLOGBAKDIR
|
||
|
|
if [ ! -f $RECOVERY_LOG ];then
|
||
|
|
touch $RECOVERY_LOG
|
||
|
|
fi
|
||
|
|
if [ ! -f $BAKUP_LOG ];then
|
||
|
|
touch $BAKUP_LOG
|
||
|
|
fi
|
||
|
|
#cp -f $BINLOGDIR/binlog.[0-9]* $BINLOGBAKDIR
|