mysql hotcopy原理_Mysql自动备份--hotcopy

将数据库直接复制一份，自动加锁，只适用于MYISAM表，脚本如下：

#! /bin/bash

# use like this : hotcopydb db1 db2 db3 ...

dbsum=$#

backdir=/opt/hotbackup/myisam

if [ "${dbsum}" -eq 0 ];then

echo "Error:no database chosed"

exit 1

fi

if [ -d ${backdir} ];then

echo "${backdir} exist!"

else

mkdir -p ${backdir}

fi

LogFile=/var/log/hotcopy_backup.log

touch $LogFile

datetime=`date +"%Y%m%d%H%M%S"`

hotcopypath=${backdir}${datetime}

mkdir -p ${hotcopypath}

echo "------------------------------------------------------------------" >> $LogFile

cd ${backdir}

while [ "`ls  ${backdir} | wc -l`" -gt 2 ]

do

rm -rf `ls | head -1`

done

echo "hotcopy start at [`date +"%Y-%m-%d %H:%M:%S"`]" >> $LogFile

for i in $*;do

echo "backing up for database $i starting ..."

/usr/local/mysql/bin/mysqlhotcopy -uroot -p123456 --flushlog $i ${hotcopypath}

echo "backing up for database $i completed"

done

echo "hotcopy   end at [`date +"%Y-%m-%d %H:%M:%S"`]" >> $LogFile

echo "tar and gzip the backed file now ..." >> $LogFile

cd ${backdir}

tar zcvf  ${datetime}.tar.gz ${datetime}

rm -rf  ${datetime}

echo "all success ! you  can find the backed file in ${backdir} suffixed by .tar.gz" >> $LogFile

exit 0