#!/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
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
然后重启数据库