- 云生2012-09-28论坛元老31003
- 本帖最后由 云生 于 2012-9-28 18:35 编辑 *
这是一段用dropbox自动备份数据库的脚本,代码取自:http://www.hostloc.com/thread-114247-1-1.html
我发现有一点问题。注意看第5行和第38行我的注释。
- #!/bin/bash
- DBName=修改为数据库名
- DBUser=修改为数据库用户名
- DBPasswd=修改为数据库密码
- BackupPath=/root/Dropbox/ ########(注意看,是保存到同步目录里)
- LogFile=/root/db.log
- DBPath=/usr/local/mysql/var/ #备份的数据库目录
- #BackupMethod=mysqldump
- #BackupMethod=mysqlhotcopy
- #BackupMethod=tar
- - NewFile="$BackupPath"db$(date +%y%m%d).tgz
- DumpFile="$BackupPath"db$(date +%y%m%d)
- OldFile="$BackupPath"db$(date +%y%m%d --date='5 days ago').tgz #自动删除5天前的备份
- 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
- mysqldump -u $DBUser --opt $DBName > $DumpFile
- else
- mysqldump -u $DBUser -p$DBPasswd --opt $DBName > $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
- ;;
- *)
- service mysql stop >/dev/null 2>&1
- tar czvf $NewFile $DBPath$DBName >> $LogFile 2>&1
- service mysql start >/dev/null 2>&1
- echo "[$NewFile]Backup Success!" >> $LogFile
- ;;
- esac
- fi
- echo "-------------------------------------------" >> $LogFile复制代码