MySQL Incremental backup script (innobackupex)
1. in the online environment, I sometimes write a simple script for Incremental backup of the MySQL database.
2. Add an automatic task and execute it every hour or shorter.
#! /Bin/sh
# Author RuM
# Date 2015-07-10
BAKDIR =/tmp/mysqlbak
BAKDIR_FULL = $ BAKDIR/full
BAKDIR_ADD = $ BAKDIR/add
CONF =/etc/my. cnf
Passswd = 123456
INNOBACKUPEX =/usr/bin/innobackupex
# During the first execution, a full backup and Incremental Backup will be performed. In the future, Incremental Backup will be performed.
If [-f "$ INNOBACKUPEX"]
Then
If [-d "$ BAKDIR"]
Then
Echo "is OK"
Else
Mkdir $ BAKDIR_FULL-p
Mkdir $ BAKDIR_ADD-p
Fi
#### Full backup
Files = 'ls $ BAKDIR_FULL'
If [-z "$ files"]
Then
$ INNOBACKUPEX -- defaults-file = $ CONF -- user = root -- password = $ PASSWD $ BAKDIR_FULL
FULLNAME = $ (dir "$ BAKDIR_FULL ")
$ INNOBACKUPEX -- defaults-file = $ CONF -- user = root -- password = $ PASSWD -- incremental-basedir = $ BAKDIR_FULL/$ FULLNAME/-- incremental $ BAKDIR_ADD
Else
#### Incremental Backup
ADDNAME = $ (ls-lt $ BAKDIR_ADD | sed-n 2p | awk '{print $9 }')
$ INNOBACKUPEX -- defaults-file = $ CONF -- user = root -- password = $ PASSWD -- incremental-basedir = $ BAKDIR_ADD/$ ADDNAME/-- incremental $ BAKDIR_ADD
Fi
Else
Echo "is not install innobackupex"
Fi
This article permanently updates the link address: