Mysql自动备份--dump

huifeideluotuo

mysql自动备份成sql格式，脚本如下：

#/usr/local/crontab/dumpbackup
# use like this : dumpbackup db1 db2 db3 ...
#! /bin/bash
dbsum=$#
if [ "${dbsum}" -eq 0 ];then
echo "Error:no database chosed"
exit 1
fi
mkdir -p /opt/hotbackup/innodb/
backdir=/opt/hotbackup/innodb/
touch  /var/log/pixplayerbackup.log
datetime=`date +"%Y%m%d%H%M"`
filesum=`ls  ${backdir} | wc -l`
if [ "${filesum}" -ge 5 ];then
cd ${backdir}
rm -rf `ls | head -1`
fi
cd /usr/local/mysql/bin
for i in $*;do
echo "backing up for database $i starting ..."
/usr/local/mysql/bin/mysqldump -uroot -p123456 --flush-logs --opt --default-character-set=utf8 $i > ${backdir}$i.sql
echo "backing up for database $i completed"
done
echo "tar and gzip the backed file now ..."
cd ${backdir}
tar -c *.sql | gzip >./${datetime}.tar.gz
rm -rf *.sql
echo "all success ! you  can find the backed file in ${backdir} suffixed by .tar.gz"
exit 0

脚本说明，保留最近5天的备份，将数据库备份成sql格式，这种备份能保证数据备份的完整性及正确性。

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/25264/showart_506893.html