mysql ¶¨Ê±Êý¾Ý±¸·Ý

1.±àдshell½Å±¾
vi /data/www/project_name/bin/mysql_backup.sh
#!/bin/bash
#This is a ShellScript For Auto DB Backup
#Powered by liuzheng

#ϵͳ±äÁ¿¶¨Òå
DBName=test
DBUser=root
DBPasswd=123456
BackupPath=/tmp/mysql_backup/

NewFile="$BackupPath"db$(date +%y%m%d).tar.gz
DumpFile="$BackupPath"db$(date +%y%m%d).sql
OldFile="$BackupPath"db$(date +%y%m%d --date='1 days ago').tar.gz


#´´½¨±¸·ÝÎļþ
if [ ! -d $BackupPath ]; then
mkdir $BackupPath
fi

echo "---------------------------"
echo $(date +"%y-%m-%d %H:%M:%S")
echo "---------------------------"

#ɾ³ýÀúÊ·Îļþ
if [ -f $OldFile ]; then
¡¡¡¡rm -f $OldFile >> $LogFile
¡¡echo "[$OldFile]Delete Old File Success!"
else
echo "not exist old file!"
fi

#ÐÂÎļþ
if [ -f $NewFile ]; then
echo "[$NewFile] The Backup File is exists,Can't Backup! "
else
mysqldump -u $DBUser -p $DBPasswd $DBName > $DumpFile
tar czvf $NewFile $DumpFile
rm -rf $DumpFile
echo "[$NewFile]Backup Success!"
fi

2.¼Ó½øcrontab -e
#ÿÌìÔçÉÏ6µã¶¨Ê±±¸·ÝÒ»´Î
* 6 * * * /letv/app/php-5.2.6-fastcgi/bin/php-cgi /data/www/project_name/bin/mysql_backup.sh