Shell Script Logical Backup Database

[Zxw@host1 ~]$ nl shscp/dump_backup_my.sh
1 #!/bin/bash
2 #dump MySQL data once per day, the reserve last 7 days data.
3 #zhao Xiaowei
4 #2014.08.27

5 Path=/bin:/sbin:/usr/bin:/usr/local/bin:/usr/local/sbin:~/bin
6 Export PATH

7 dir= "/home/zhaoxiaowei/data_db/"
8 filename_prefix= "Data_1db_"
9 datenow= ' Date--date= +%y%m%d '
Backupfile=${dir}${filename_prefix}${datenow} ". sql"
One logfile= "/home/zxw/shdir/logfile.log"

Mailaddr= "Xxx@xxx.com xyz@xxx.com"

echo "-----------------------------" >> $LOGFILE
echo $ (date--date= +%y%m%d) >> $LOGFILE

Mysqldump-h ip-uusername-p ' XXXXXX '--events--ignore-table=mysql.events--single-transaction-a > $BACKUPFILE
Find $DIR-mtime +7-exec rm ' {} ' \; >> $LOGFILE 2>&1

If [f $BACKUPFILE]
Then
echo "xxx successfully." >> $LOGFILE
echo "$BACKUPFILE is ok!" >> $LOGFILE
Else
echo "failure when xxx." >> $LOGFILE
echo "$BACKUPFILE dump failure!!!" >> $LOGFILE
ECHO-E "$DATENOW failure when xxx" | Mail-s "$DATENOW failure when xxx" $MAILADDR
Fi

Reprint please the Source:
Blog.csdn.net/beiigang