- 论坛徽章:
- 1
|
echo ""
writeLog "backup database $DB_DATABAASE BIN-LOG......"
cd $MYSQL_HOME/
$MYSQL_PATH -h $DB_HOST -P $DB_HOST_PROT -u $DB_USER -p$DB_PASSWORD -e "use $DB_DATABAASE;flush logs;"
COUNTER=$(echo `cat mysql-bin.index|wc -l` -1 |bc)
for i in `sed -n 1,${COUNTER}p mysql-bin.index`
do
if (test -d $DATA_PATH/MYSQL-BINLOG-`date +%Y%m%d`)
then
cp -af $i $DATA_PATH/MYSQL-BINLOG-`date +%Y%m%d`/
else
mkdir $DATA_PATH/MYSQL-BINLOG-`date +%Y%m%d`/
cp -af $i $DATA_PATH/MYSQL-BINLOG-`date +%Y%m%d`/
fi
done
writeLog "backup mysql-bin-log...done"
echo "" |
我以前用过的。
这个增量没什么特别的,无非就是把biglog复制出来。 |
|