mysql 备份脚本
全量备份:
#!/bin/bash
#mysql全量备份脚本
#mkdir/backup
cd/backup
dateDIR=`date+"%y-%m-%d"`
mkdir-p$dateDIR/data
path=/var/lib/mysql
foriin`mysql-uroot-p123456-e"showdatabases"|grep-v"Database"`
do
mysqldump-uroot-p123456--opt$i--skip-lock-tables|gzip>/backup/$dateDIR/data/${i}_${dateDIR}.sql.gz
done
mysqladmin-uroot-p123456flush-logs
binlog_rm=`tail-n1$path/mysql-bin.index|sed's/.\///'`
mysql-uroot-p123456-e"purgebinarylogsto'$binlog_rm'"
~
增量备份:
#!/bin/bash
#mysql增量备份脚本
cd/backup
dateDIR=`date+"%y-%m-%d"`
mkdir-p$dateDIR/data
path=/var/lib/mysql
mysqladmin-uroot-p123456flush-logs
binlog_cp=`head-n-1$path/mysql-bin.index|sed's/.\///'`
foriin$binlog_cp
do
mysql-uroot-p123456-e"FLUSHTABLESWITHREADLOCK;\!cp-p$path/$i/backup/$dateDIR/data/;"
done
binlog_rm=`tail-n1$path/mysql-bin.index|sed's/.\///'`
mysql-uroot-p123456-e"purgebinarylogsto'$binlog_rm'"
本文转自 jxzhfei 51CTO博客,原文链接:http://blog.51cto.com/jxzhfei/1305848