Detained

Dur Detainedslut Is Varnams Shtml Detained Slut sunnyu Dur Detainedslut Is Varnams Shtml Detained Slut

sbin:/usr/bin:/bin

#get cur date str 2008-10-12

DATE=`date -I`

TIME=' 01:0:0'

DAYSTARTTIME=" $DATE $TIME"

#set backup path info

DATADIR="/var/lib/mysql"

BAK_DIR="/backup/$DATE"

#set mysql user name and password

MYSQL_USER="root"

MYSQL_PWD="rootpwd"

MYACC=" -u'$MYSQL_USER' -p'$MYSQL_PWD' "

cp -r $BAK_DIR $DATA_DIR

HOST=`hostname -s`

for binfile in `ls $DATA_DIR/$HOST-bin.0* |sort`; do

RESTORECMD="mysqlbinlog –start-datetime='$DAYSTARTTIME' $binfile | mysql $MYACC "

eval $RESTORECMD

done

Popularity: 26% [?]

Tags：MySQL, mysqlbinlog.
October 21, 2008 | Filed Under MySQL | Leave a Comment

在提出 MySQL主从结构灾难恢复策略机制设想后尝试编写用于以上目的的备份脚本。

每日一个全量备份，同时做binlog 的删减(只保留一个小时的日志，根据需要可以做延时)，然后每小时对日志文件做增量部分的备份。