一、Mysql全量备份脚本
#!/bin/bash
mkdir /a8root
cd /a8root
dateDIR=`date +"%y-%m-%d"`
mkdir -p $dateDIR/data
path=/var/lib/mysql/data
for i in `mysql -uroot -p12345 -e "show databases" | grep -v "Database"`
do
mysqldump -uroot -p12345 --default-character-set=gbk --opt $i | gzip > /a8root/$dateDIR/data/${i}_${dateDIR}.sql.gz
done
mysqladmin -uroot -p12345 flush-logs
binlog_rm=`tail -n 1 $path/mysql-bin.index | sed 's/.///'`
mysql -uroot -p123456 -e "purge binary logs to '$binlog_rm'"
二、Mysql增量备份脚本
#!/bin/bash
cd /a8root
dateDIR=`date +"%y-%m-%d"`
mkdir -p $dateDIR/data
path=/var/lib/mysql/data
mysqladmin -uroot -p12345 flush-logs
binlog_cp=`head -n -1 $path/mysql-bin.index | sed 's/.///'`
for i in $binlog_cp
do
mysql -uroot -p12345 -e "FLUSH TABLES WITH READ LOCK; ! cp -p $path/$i /a8root/$dateDIR/data/;"
done
binlog_rm=`tail -n 1 $path/mysql-bin.index | sed 's/.///'`
mysql -uroot -p12345 -e "purge binary logs to '$binlog_rm'"
最新评论