mysqlhotcopy 热备份和恢复

#!/bin/bash
PATH=/usr/local/sbin:/usr/bin:/bin
#the directory of backup
BACKDIR=/home/wwwroot/mysql-backup
BACKDIRTMP=/home/wwwroot/mysqlbaktmp
#the passwd of mysql
ROOTPASS=passwd
rm -rf $BACKDIRTMP
mkdir -p $BACKDIRTMP
#DBLIST=`ls -p /var/lib/mysql | grep / | tr -d /`
DBLIST=dbname
for dbname in $DBLIST
do
mysqlhotcopy -u root -p $ROOTPASS $dbname $BACKDIRTMP | logger -t mysqlhotcopy
done
rm -rf $BACKDIR
mkdir -p $BACKDIR

cp -r $BACKDIRTMP/* $BACKDIR

chmod -R 755 $BACKDIR

恢复数据可以直接把数据库目录拷回mysql数据目录

/var/lib/mysql

注意把文件所有者改成mysql:mysql

然后重启数据库