两个备份数据库的shell脚本

2019-09-23 09:48:27刘景俊

   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  
   echo "Begin ro recover the data...."   
   mysql -u$LocalDBUser -p$LocalDBPasswd --default-character-set='utf8' $LocalDBName <$NewFile 
   echo "Data has been restored!" >>$LogFile 
else   
    mysqldump -h$SERVER -u$DBUser -p$DBPasswd --default-character-set='utf8' --quick --single-transaction  $DBName  $NeedTables    $IgnoreTables  >$NewFile 
    echo "[$NewFile]Backup Success!" >> $LogFile   
fi 
echo "-------------------------------------------" 
echo "作者 陈建虹"