MySQL Incremental backup script (innobackupex)

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: