5遗忘之海5 5遗忘之海5
宇宙何等浩瀚,人的生命是何等的脆弱。
关注数: 2 粉丝数: 2 发帖数: 211 关注贴吧数: 13
Linux mysql自动备份问题 #!/bin/sh #this is a auto backup script #powered by kanon #2009-10-11 #setting start #set the dbname,dblogin,dbpswd,bckpath,logpath,and bckmethod DBName=mysql DBUser=root DBPasswd=gtjy2009 BackupPath=/usr/local/www/back/ LogFile=/usr/local/www/back/bck.log DBPath=/usr/local/mysql/ BackupMethod=mysqldump #BackupMethod=myqlhotcopy BackupMethod=tar #setting end NewFile="$BackupPath""$DBName"$(date +%Y%m%d).tgz DumpFile="$BackupPath""$DBName"$(date +%Y%m%d) OldFile="$BackupPath""$DBName"$(date +%Y%m%d --date='5 days ago').tgz echo date +%Y%m%d >> $LogFile echo "-----------------start backup--------------------------------------" >> $LogFile echo "-----------------------------check and delete old file-------------">>$LogFile #delete old file if [ -f $OldFile ] then rm -f $OldFile echo "[$OldFile] delete old file success!">>$LogFile else echo "[$OldFile] no old file!">>$LogFile fi echo "-----------------------------create new file-------------">>$LogFile if ///到这里就不在执行了,这是为什么呢 求大神 帮助一下 [ -f $NewFile ] then echo "[$NewFile] the file is exists">>$LogFile else case $BackupMethod in /usr/local/mysql/bin/mysqldump) if [ -z $DBPasswd ] then /usr/local/mysql/bin/mysqldump -u$DBUser --opt $DBName>$DumpFile else /usr/local/mysql/bin/mysqldump -u$DBUser -p$DBPasswd --opt $DBName>$DumpFile fi tar czvf @NewFile $DumpFile echo "[$NewFile] backup success!">>$LogFile rm -rf $DumpFile ;; /usr/local/mysql/bin/mysqlhotcopy) rm -rf $DumpFile mkdir $DumpFile if [-z $DBPasswd] then /usr/local/mysql/bin/mysqlhotcopy -u$DBUser $DBName $DumpFile else /usr/local/mysql/bin/mysqlhotcopy -u$DBUser -p$DBPasswd $DBName $DumpFile fi tar czvf $NewFile $DumpFile echo "[$NewFile] backup success!">>$LogFile rm -rf $DumpFile ;; esac fi echo "-----------------backup over--------------------------------------" >> $LogFile
1 下一页