Linux定时自动备份数据库并上传至FTP的脚本

•#!/bin/bash
•MYSQL_USER=root
•MYSQL_PASS=root
•FTP_USER=ftp
•FTP_PASS=123456
•FTP_IP=www.is36.com
•FTP_backup=/public_html/
•WEB_DATA=/home/wwwroot/
•
•DataBakName=Data_$(date +"%Y%m%d").tar.gz
•WebBakName=Web_$(date +%Y%m%d).tar.gz
•OldData=Data_$(date -d -5day +"%Y%m%d").tar.gz
•OldWeb=Web_$(date -d -5day +"%Y%m%d").tar.gz
•rm -rf /home/backup/Data_$(date -d -3day +"%Y%m%d").tar.gz /home/backup/Web_$(date -d -3day +"%Y%m%d").tar.gz
•cd /home/backup
•for db in `/usr/local/mysql/bin/mysql -u$MYSQL_USER -p$MYSQL_PASS -B -N -e 'SHOW DATABASES' | xargs`; do
•    (/usr/local/mysql/bin/mysqldump -u$MYSQL_USER -p$MYSQL_PASS ${db} | gzip -9 - > ${db}.sql.gz)
•done
•tar zcfP /home/backup/$DataBakName /home/backup/*.sql.gz
•rm -rf /home/backup/*.sql.gz
•tar zcfP /home/backup/$WebBakName $WEB_DATA
•
•ftp -i -n << !
•open $FTP_IP
•user $FTP_USER $FTP_PASS
•bin
•lcd /home/backup/
•cd $FTP_backup
•delete $OldData
•delete $OldWeb
•put $DataBakName
•put $WebBakName
•bye