mysql全量备份与增量备份_MYSQL全量备份和增量备份脚本

转自cu的squall1的脚本，原文：http://bbs3.chinaunix.net/viewth ...

%3Bfilter%3D2592000

mysql增量备份脚本：

CODE:

# 先用dos2unix转换下格式。

# http://blog.linuxhomes.cn/archives/259/

#!/bin/bash

# mysql增量备份脚本

cd /backup

dateDIR=`date +"%y-%m-%d"`

mkdir -p $dateDIR/data

path=/usr/local/mysql/data

mysqladmin -uroot -p123456 flush-logs

binlog_cp=`head -n -1 $path/mysql-bin.index | sed 's/.\///'`

for i in $binlog_cp

do

mysql -uroot -p123456 -e "FLUSH TABLES WITH READ LOCK; \! cp -p

$path/$i /backup/$dateDIR/data/;"

done

binlog_rm=`tail -n 1 $path/mysql-bin.index | sed 's/.\///'`

mysql -uroot -p123456 -e "purge binary logs to

'$binlog_rm'"mysql全量备份脚本：

CODE:

# 先用dos2unix转换下格式。

# http://blog.linuxhomes.cn/archives/259/

#!/bin/bash

# mysql全量备份脚本

mkdir /backup

cd /backup

dateDIR=`date +"%y-%m-%d"`

mkdir -p $dateDIR/data

path=/usr/local/mysql/data

for i in `mysql -uroot -p123456 -e "show databases" | grep -v

"Database"`

do

mysqldump -uroot -p123456

--default-character-set=gbk --opt $i | gzip >

/backup/$dateDIR/data/${i}_${dateDIR}.sql.gz

done

mysqladmin -uroot -p123456 flush-logs

binlog_rm=`tail -n 1 $path/mysql-bin.index | sed 's/.\///'`

mysql -uroot -p123456 -e "purge binary logs to

'$binlog_rm'"