备份MYSQL脚本

#!/bin/sh
# this shell to backup mysql
#[e-mail] (QQ:1413161683 DuChengJiu)

_dbDir=/var/lib/mysql/
_today=`date +%w`
_bakDir=/usr/backup/$_today
[ ! -d $_bakDir ] && mkdir -p $_bakDir
#Create db tar archive
#/usr/local/mysql/share/mysql/mysql.server stop
service mysqld stop
for db in `find $_dbDir -type d|tail -n +2`
do
        echo "Do $db ...."
        realDb=`echo $db|awk -F / '{print $NF}'`
        echo "Backup $realDb ......"
        tar cvf $_bakDir/${realDb}.tar $db || echo "$realDb   :  1" >>$_bakDir/backup-error
done

#/usr/local/mysql/share/mysql/mysql.server start
service mysqld start

#gzip backup
for zip in $_bakDir/*.tar
do
        echo "Compress $zip ........"
        gzip -f $zip
done
find $_bakDir -name "*tar" -exec rm -f {} \;

 

评论

2 楼 dcj3sjt126com 2013-02-27  

我知道了，你用的是 MySQL上海爱可生官方的产品

1 楼 duchengbin 2013-02-27  

这个不好，最好还是用专用的工具进行备份，我用的MySQL-ZRM，它还可以生成具体的备份情况的HTML。方便查看备份信息。