Linux定時自動備份資料庫並上傳至FTP的指令碼

適用於使用lnmp環境下定時自動備份網站和mysql資料庫並上傳至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