[mysql]mysqldump二进制日志备份方案 [复制链接]

#backup database
#set params
HOST=
PORT=3306
BACKUP_HOST=10.15.200.110

#set envs
DATE=`date +%Y-%m-%d`
PWD=`pwd`

#do backup
cd /backup
echo 'SHOW DATABASES;' | /usr/local/mysql/bin/mysql -S /tmp/mysql.$PORT.sock
/usr/local/mysql/bin/mysqldump --master-data=2 --opt --default-character-set=gbk -S /tmp/mysql.$PORT.sock pw > $DATE.sql

/usr/bin/bzip2 -z9k $DATE.sql
rm $DATE.sql
rsync -a --password-file=/etc/rsync.backup $DATE.sql.bz2 backup@$BACKUP_HOST::backup

#delete past files
FILES=`ls *.sql.bz2 --sort=time -1 | awk '{if(c==7){print $0}else{c++}}'`
for FILE in $FILES;
do
    rm -f $FILE;
done;

cd $PWD