#!/bin/bash #This is a ShellScript. For Auto DB Backup #Powered by [email protected] #2014/2/25#setting #设置数据库名, database login, password, backup path, log path, data file location, and backup method # By default, the backup method is tar, or it can be a mysqldump,mysqldotcopy #默认情况下, log in to the MySQL database with root (empty) and back up to/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&NBsp 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 "-------------------------------------------" >> $ logfileecho $ (date "+%f %t") >> $LogFile
MySQL Regular Backup script