Abin backup script
#! / bin/sh
#
# when it is executed for the first time, it will check whether there is a full backup, otherwise create a full library backup first
# when you run it again, it will perform incremental backups based on previous full-library backups according to the settings in the script
Commands for INNOBACKUPEX_PATH=innobackupex # INNOBACKUPEX
Command path of INNOBACKUPEXFULL=/usr/bin/$INNOBACKUPEX_PATH # INNOBACKUPEX
# mysql target server and username and password
MYSQL_CMD= "- host=192.16.2.11-user=root-password=123456-port=3306"
User name and password of MYSQL_UP= "--user=root-- password=123456-p3306" # mysql
TMPLOG= "/ tmp/innobackupex.$$.log"
Configuration file for MY_CNF=/etc/my.cnf # mysql
MYSQL=/usr/bin/mysql
MYSQL_ADMIN=/usr/bin/mysqladmin
Home directory of BACKUP_DIR=/backup # backup
FULLBACKUP_DIR=$BACKUP_DIR/full # Directory of full library backup
Directory for INCRBACKUP_DIR=$BACKUP_DIR/incre # incremental backups
Interval period of FULLBACKUP_INTERVAL=259200 # full library backups, time: seconds
KEEP_FULLBACKUP=1 # keeps at least a few full library backups
Logfiledate= backup.`date +% Y% m% d% H% M`.txt
# start time
STARTED_TIME= `date +% s`
# date +% s seconds since 00:00:00 UTC on January 1, 1970
#
# display an error and exit
#
Error ()
{
Echo "$1" 1 > & 2
Exit 1
}
# check the execution environment
If [!-x $INNOBACKUPEXFULL]; then
Error "$INNOBACKUPEXFULL is not installed or linked to / usr/bin."
Fi
#-x Test whether you have the right to execute
If [!-d $BACKUP_DIR]; then
Error "backup destination folder: $BACKUP_DIR does not exist."
Fi
If [- z "`$MYSQL_ADMIN $MYSQL_UP status | grep 'Uptime'`]; then
Error "MySQL is not up and running."
Fi
#-z empty string
If! `MYSQL_ 'exit' | $MYSQL-s $MYSQL_ CMD`; then
Error "the database username or password provided is incorrect!"
Fi
# mysql-s,-- silent / / one line of output, separated by tab
# header information of backup
Echo "-"
Echo
Echo "$0: MySQL backup script"
Echo "starts with: `date +% F'% T'% w`"
Echo
# the $0 above indicates the name of the currently running process or the name of the currently executed script
# create directories for full and differential backups
Mkdir-p $FULLBACKUP_DIR
Mkdir-p $INCRBACKUP_DIR
# find the latest full backup
LATEST_FULL_BACKUP= `find $FULLBACKUP_DIR-mindepth 1-maxdepth 1-type d-printf "% P\ n" | sort-nr | head-1`
#-mindepthd 1, indicating that the search starts at layer 0 of the $FULLBACKUP_DIR directory;-maxdepth 1, indicating that the depth of listing the files in $FULLBACKUP_DIR is up to 0 layer
# find the latest backup that was recently modified
LATEST_FULL_BACKUP_CREATED_TIME= `stat-c% Y $FULLBACKUP_DIR/$LATEST_FULL_ backUP`
# stat-c% Y get the modification time of the file
# if full and effective incremental backup is performed, otherwise perform a full backup
If ["$LATEST_FULL_BACKUP"-a `expr $LATEST_FULL_BACKUP_CREATED_TIME + $FULLBACKUP_INTERVAL + 5`-ge $STARTED_TIME]; then
# if the latest full directory is not expired, create a new directory under the incremental backup directory with the latest full file name
Echo-e "full backup $LATEST_FULL_BACKUP has not expired and will be named as the incremental backup directory according to the $LATEST_FULL_BACKUP name"
Echo ""
NEW_INCRDIR=$INCRBACKUP_DIR/$LATEST_FULL_BACKUP
Mkdir-p $NEW_INCRDIR
# find out whether the latest incremental backup exists. Specify the path of a backup as the basis for incremental backup
LATEST_INCR_BACKUP= `find $NEW_INCRDIR-mindepth 1-maxdepth 1-type d | sort-nr | head-1`
If [! $LATEST_INCR_BACKUP]; then
INCRBASEDIR=$FULLBACKUP_DIR/$LATEST_FULL_BACKUP
Echo-e "incremental backup will be based on $INCRBASEDIR"
Echo ""
Else
INCRBASEDIR=$LATEST_INCR_BACKUP
Echo-e "incremental backup will be based on $INCRBASEDIR"
Echo ""
Fi
Echo "uses $INCRBASEDIR as the basis for new incremental backups."
$INNOBACKUPEXFULL-defaults-file=$MY_CNF-use-memory=4G $MYSQL_CMD-incremental $NEW_INCRDIR-incremental-basedir $INCRBASEDIR > $TMPLOG 2 > & 1
Else
Echo "* *"
Echo-e "is performing a new full backup... just a moment, please."
Echo "* *"
$INNOBACKUPEXFULL-defaults-file=$MY_CNF-use-memory=4G $MYSQL_CMD $FULLBACKUP_DIR > $TMPLOG 2 > & 1
Fi
#-use-memory this parameter is used in prepare to control the amount of memory used by innodb instances in prepare
# keep a detailed log of a backup
Cat $TMPLOG > / backup/$logfiledate
If [- z "`tail-1$ TMPLOG | grep 'innobackupex: completed Okla``"]; then
Echo "$INNOBACKUPEX command execution failed:"; echo
Echo-e "- $INNOBACKUPEX_PATH error -"
Cat $TMPLOG
Rm-f $TMPLOG
Exit 1
Fi
THISBACKUP= `awk-"/ Backup created in directory/ {split (\\ $0, p,\"'\ "); print p [2]}" $TMPLOG`
Rm-f $TMPLOG
Echo-n "Database successfully backed up to: $THISBACKUP"
Echo
# prompt the starting point of the backup file that should be retained
LATEST_FULL_BACKUP= `find $FULLBACKUP_DIR-mindepth 1-maxdepth 1-type d-printf "% P\ n" | sort-nr | head-1`
Echo-e "must keep $KEEP_FULLBACKUP full and all incremental backups after $LATEST_FULL_BACKUP."
# Delete expired completeness
Echo-e "look for expired complete files and delete" > > / backup/$logfiledate
For efile in $(/ usr/bin/find $FULLBACKUP_DIR/-mtime + 6)
Do
If [- d $efile]; then
Rm-rf $efile
Echo-e "Delete expired complete files: $efile" > > / backup/$logfiledate
Elif [- f $efile]; then
Rm-rf $file
Echo-e "Delete expired complete files: $efile" > > / backup/$logfiledate
Fi
Done
If [$?-eq "0]; then
Echo
Echo-e "No expired complete files found to delete"
Fi
Echo
"echo" is completed at: `date +% F''% T'
