MySQL增量备份脚本

#!/bin/sh
#
# Created by david yeung at 2008-09-16
#
# File name:backup_increment
#
# Backup mysql's increment data after daily backup.
#
# Usage:
# If you database name is t_girl and you want to backup from 2008-09-16 08:13:26.
# ./backup_increment t_girl 20080916081326
#
# You can simple put this file into crontab in order to work automatically.
#
# Put your own database name here.
DBNAME=$1

# You own specific datatime.
# For example,2008-09-16 08:13:26 should be replaced with 20080916081326 here.
#
USERDATETIME=$2

# You own backup directory.
BACKUPDIR=/home/david_yeung/backup_db

# You own backup user.
# He must have lock tables,select,super privileges.
# Also replication client privileges if your mysqld was set up as Master/Slave.
USERNAME=backup_user
PASSWD=123456

# Socket path.
SOCKET=/tmp/mysql_3306.sock

# All the binary logs.
LOG=/usr/local/mysql/data/ytt-bin.[0-9]*

# Backup file name.
TARNAME="$BACKUPDIR"/incrementbackup"$1""$2"

# Copy all the binary logs here to prevent failed backup.
cp -rf `echo $LOG` /home/david_yeung/logs

# Change the current directory.
# If you have aready put mysql into your environment variable named path,you can comment this line and use simple mysql instead of /bin/mysql.
#
cd /usr/local/mysql

bin/mysql -u$USERNAME -p"$PASSWD" -S$SOCKET -e "purge master logs before ${USERDATETIME}"
bin/mysqlbinlog -u$USERNAME -p"$PASSWD" -S$SOCKET -d$DBNAME `echo $LOG` --start-datetime="$USERDATETIME"> "$TARNAME"

原文:http://blog.chinaunix.net/u/29134/showart_1194259.html

上一篇: 山寨卫星锅完美破解   下一篇: MySQL 备份恢复——二进制增量备份

提交疑问

回顶部