liunx下实现mysql自动定时备份

编写shell脚本.

#!/bin/sh##This is a ShellScript For Auto DB Backup#Powerd by hiker#2012-02DBHost=127.0.0.1DBName=testDBUser=rootDBPassword=123456BackupPath=/data/mysqldata/LogFile=/data/log/backup.log#BackupMethod=mysqldump#BackupMethod=mysqlhotcopy#Setting EndNewFile="$BackupPath$DBName"$(date +%Y%m%d).sqlDumpFile="$BackupPath$DBName"$(date +%Y%m%d).sqlOldFile="$BackupPath$DBName"$(date +%Y%m%d --date='5 days ago').sql#Delete Old Fileif [ -f $OldFile ]thenrm -f $OldFile >> $LogFile 2>&1echo "[$OldFile]Delete Old File Success!" >> $LogFileelseecho "[$OldFile]No Old Backup File!" >> $LogFilefiif [ -f $NewFile ]then echo "[$NewFile]The Backup File is exists,Can't Backup!" >> $LogFileelse mysqldump -h $DBHost -u $DBUser -p$DBPassword $DBName>$DumpFilefi

vi etc/crontab01 7 * * * root /data/sh/backupmysql //每天早上7点1分执行/sbin/service crond restart