使用mysqldump備份

#!/bin/bash

This is a ShellScript. For Auto DB Backup
Powered by alex@wg927.com
2014/2/25
Setting
設置數據庫名，數據庫登錄名，密碼，備份路徑，日志路徑，數據文件位置，以及備份方式
默認情況下備份方式是tar，還可以是mysqldump,mysqldotcopy
默認情況下，用root(空)登錄mysql數據庫，備份至/root/dbxxxxx.tgz
DBName=(mysql wm_ztcj)
DBUser=root
DBPasswd='xxx'
BackupPath=/data/backup/ 
LogFile=/data/backup/backup.log
DBPath=/data/mysqldata/
BackupMethod=mysqldump
BackupMethod=mysqlhotcopy
BackupMethod=tar
Setting End
NewFile="$BackupPath"db$(date +%y%m%d).tar.gz 
DumpFile="$BackupPath"db$(date +%y%m%d) 
OldFile="$BackupPath"db$(date +%y%m%d --date='5 days ago').tar.gz
echo "-------------------------------------------" >> $LogFile 
echo $(date +"%y-%m-%d %H:%M:%S") >> $LogFile 
echo "--------------------------" >> $LogFile
Delete Old File
if [ -f $OldFile ] 
then 
    rm -f $OldFile >> $LogFile 2>&1 
    echo "[$OldFile]Delete Old File Success!" >> $LogFile 
else 
    echo "[$OldFile]No Old Backup File!" >> $LogFile 
fi
if [ -f $NewFile ] 
then 
    echo "[$NewFile]The Backup File is exists,Can't Backup!" >> $LogFile 
else 
    case $BackupMethod in 
        mysqldump)
if [ -z $DBPasswd ]
then
/usr/local/mysql/bin/mysqldump -u $DBUser --opt --all-databases > $DumpFile
else

        /usr/local/mysql/bin/mysqldump -uroot -h127.0.0.1 --single-transaction --default-character-set=utf8 -R -E --hex-blob --all-databases --master-data=1 --opt  > $DumpFile 

    #   /usr/local/mysql/bin/mysqldump -u $DBUser -p$DBPasswd --default-character-set=utf8 --triggers -R -E --hex-blob wm_ztcj --master-data=1 --opt > $DumpFile  

fi

    tar czvf $NewFile $DumpFile >> $LogFile 2>&1 
    echo "[$NewFile]Backup Success!" >> $LogFile 
    rm -rf $DumpFile 
    ;; 
    mysqlhotcopy) 
    rm -rf $DumpFile 
    mkdir $DumpFile 
    if [ -z $DBPasswd ] 
    then 
        mysqlhotcopy -u $DBUser $DBName $DumpFile >> $LogFile 2>&1 
    else 
        mysqlhotcopy -u $DBUser -p $DBPasswd $DBName $DumpFile >>$LogFile 2>&1 
    fi 
    tar czvf $NewFile $DumpFile >> $LogFile 2>&1 
    echo "[$NewFile]Backup Success!" >> $LogFile 
    rm -rf $DumpFile 
    ;; 
    *) 
    /etc/init.d/mysqld stop >/dev/null 2>&1 
    tar czvf $NewFile $DBPath$DBName >> $LogFile 2>&1 
    /etc/init.d/mysqld start >/dev/null 2>&1 
    echo "[$NewFile]Backup Success!" >> $LogFile 
    ;; 
esac 

fi 
echo "-------------------------------------------" >> $LogFile
echo $(date "+%F %T") >> $LogFile</pre>來自：http://my.oschina.net/u/1440383/blog/313803</span>