linux中利用mysqlhotcopy备份数据脚本示例

#!/bin/bash

# Enviroment
PATH=/usr/local/sbin:/usr/bin:/bin

# Configure The Directory of Backup
BACKUPDIR=/data/backup/mysql # mysql backup dir
SAVE=4 #how many days to save lastest
HOST=192.168.10.32 # mysql host
ROOT=root # mysql account
ROOTPASS='XXXXXX' # mysql root password
DUMPLIST='mysql database1 database2 database3' # backup with mysqldump
HOTCOPYLIST='database4' # backup with mysqlhotcopy

# define
SQLDIR=$BACKUPDIR/sql/ # mysqldump to sql save path
HOTCOPYDIR=$BACKUPDIR/hotcopy/ # mysqlhotcopy copy files path
TMPDIR=$BACKUPDIR/tmp # temporary dir
DATETIME=`date -d now +%Y-%m-%d_%H-%M` # create date dir

# Create Directory
if [ ! -d $SQLDIR ]; then
  mkdir -p $SQLDIR
fi

if [ ! -d $HOTCOPYDIR ]; then
  mkdir -p $HOTCOPYDIR
fi

rm -rf $TMPDIR
mkdir -p $TMPDIR

# ----- Backup MySQL -----

# Backup with Database
for dbname in $DUMPLIST
do
    mysqldump -h$HOST -u$ROOT -p$ROOTPASS $dbname > $TMPDIR/$dbname.sql
done

for dbname in $HOTCOPYLIST
do
   mysqlhotcopy -u $ROOT -p $ROOTPASS $dbname $TMPDIR
done

# move hotcopy dir
cd $HOTCOPYDIR
mkdir -p $DATETIME
cd $DATETIME
for dbname in $HOTCOPYLIST
do
   mv ../../tmp/$dbname ./
done

# create MySQL tar
cd $SQLDIR
tar -czf $SQLDIR/mysql_backup.$DATETIME.tar.gz ../tmp
rm -fr $TMPDIR
find $SQLDIR -type f -mtime +$SAVE | xargs rm -f
find $HOTCOPYDIR -type d -mtime +$SAVE | xargs rm -rf