linux下mysql数据库备份脚本
#!/bin/bash
#This is a ShellScript For Auto DB Backup
#Powered by RoberT
#2007-11
#Setting
DBName=xineurope
DBUser=root
DBPasswd=
BackupPath=/home/BACKUP/
LogFile=/home/BACKUP/db.log
DBPath=/usr/local/mysql5.0.45/
BackupMethod=mysqlhotcopy
#Setting End
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
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
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 zcvf $NewFile $DumpFile >;>; $LogFile 2>;&1
echo “[$NewFile]Backup Success!” >;>; $LogFile
rm -rf $DumpFile
fi
echo “——————————-” >;>; $LogFile
