一个脚本

#!/bin/bash
export LANG=en_US.UTF-8
export LC_CTYPE="zh_CN.UTF-8"
function usage()
{
cat << EOF
Usage: $0 [OPTION]
-?,--help show this help and exit
--user=<> set the username to connect the mysql
--password=<> set the password to connect the mysql
--backuptype=<> set the type of backup,such as DATA_FULL,DATA_INC
--defaults-file=<> set the config file
--backup_path=<> set the remote host by formate name@host
--innoback=<> set the full path of the innoback
--xtraback=<> set the full path of the xtraback
EOF
}
function get_option()
{
echo "$1" | sed 's/=[/a-zA-Z0-9]*$//' | sed 's/^--//' | tr '[a-z]' '[A-Z]'
}
function get_option_value()
{
echo "$1" | sed 's/^--[a-zA-Z_-]*=//'
}
function parse_option()
{
while test $# -gt 0
do
case $1 in
--user=*)
USER=`get_option_value "$1"`
echo "USER : $USER"
;;
--password=*)
PASSWORD=`get_option_value "$1"`
echo "PASSWORD : $PASSWORD"
;;
--backup_path=*)
BACKUP_PATH=`get_option_value "$1"`
echo "BACKUP_PATH : $BACKUP_PATH"
;;
--defaults-file=*)
MYCNF=`get_option_value "$1"`
echo "MYCNF : $MYCNF"
;;
--backuptype=*)
BACKUPTYPE=`get_option_value "$1"`
echo "BACKUPTYPE : $BACKUPTYPE"
;;
--innoback=*)
INNOBACK=`get_option_value "$1"`
#echo "INNOBACK : $INNOBACK"
;;
--xtraback=*)
XTRABACK=`get_option_value "$1"`
#echo "XTRABACK : $XTRABACK"
;;
-?|--help)
usage
exit 0
;;
*)
echo "Unknown option '$1'"
;;
esac
shift
done
}
back_full()
{
parse_option
$INNOBACK --user=$USERNAME --password=$PASSWORD --defaults-file=$MYCNF --no-timestamp $DATA_FULL/base$DATE
2> $DATA_FULL/timestamp$DATE.log
grep 'INNOBACKupex: completed OK!' $DATA_FULL/timestamp$DATE.log
}
back_inc()
{
parse_option
$XTRABACK --defaults-file=$MYCNF --user=$USERNAME --password=$PASSWORD --backup --target-dir=$DATA_I
NC/base_inc$DAY --incremental-basedir=$DATA_FULL/base`date -d "$DAY days ago" +%F` 2> $DATA_INC/timestamp$DATE
_inc.log
}
# XTRABACKup conf
MYCNF=/home/data/mydata/3308/my.cnf
USERNAME=root
PASSWORD=ESBecs00
BACKUP_PATH=/xback
DATA_FULL=$BACKUP_PATH/back_data_full
DATA_INC=$BACKUP_PATH/back_data_inc
INNOBACK=/usr/bin/innobackupex
XTRABACK=/usr/bin/xtrabackup
mkdir -p $DATA_FULL $DATA_INC
DAY=`date +%w`
echo $DAY
#0
DATE=`date +%F`
echo $DATE
#2015-11-22
case $DAY in
0)
# Sunday Full backup
back_full
;;
1)
# Monday Relatively Sunday's incremental backup
back_inc
;;
2)
# Tuesday Compared with Monday's incremental backup
back_inc
;;
3)
# Wednesday Full backup
back_inc
;;
4)
# Thursday Relatively Wednesday's incremental backup
back_inc
;;
5)
# Friday Compared with Thursday's incremental backup
back_inc
;;
6)
# Saturday Compared with Friday
back_inc
;;
esac

http://www.dataguru.cn/forum.php?mod=viewthread&tid=344887&extra=
点评：有备份策略，代码逻辑也比较完善。
http://f.dataguru.cn/forum.php?mod=viewthread&tid=344627&page=1&extra=
点评：备份逻辑完整，但是没有体现备份策略和自动化。
http://f.dataguru.cn/thread-342368-1-1.html
点评：很多人都直接借用了，不得不说好。

ITPub博客

课时7-备份与恢复----数据库备份策略脚本

最新文章