Linux 備份文件和數據庫發送到郵箱

2. #!/bin/bash
3. # X , sendmail hoodbc20117
4. ### Setting path ###
5. BACKPATH="/data0/mysql_bak"
6. DATE=`/bin/date "+%Y-%m-%d-%H-%M-%S"`
8. zip -rq $BACKPATH/erp_$DATE.zip /data/htdocs/www/erp/
9. echo "erp all backup" | mutt -a $BACKPATH/erp_$DATE.zip -s "erp all backup" [email protected]
11. find $BACKPATH -ctime +30 -name *.zip -delete

順便把數據庫備份的腳本也記錄下來：

1. #!/bin/bash
2. # hoodbc20117
4. ### database setting ###
5. USER='root'
6. PASSWORD=''
7. HOST="127.0.0.1"
8. DATABASES=(erp)
10. ### Setting path ###
11. MYSQLDUMP=/usr/local/webserver/mysql/bin/mysqldump
12. BACKPATH="/data0/mysql_bak"
14. DATE=`/bin/date "+%Y-%m-%d-%H-%M-%S"`
15. for DATABASE in ${DATABASES[*]}
16. do
17. FILENAME="$DATABASE-$DATE"
19. $MYSQLDUMP --add-drop-table --user $USER --password=$PASSWORD $DATABASE --lock-all-tables>> "$BACKPATH/$FILENAME.sql"
20. done
22. #tar zcf -r $BACKPATH/erp_$DATE.tar.gz ~/data/htdocs/www/erp
23. #zip -rq $BACKPATH/erp_$DATE.zip /data/htdocs/www/erp/
24. zip -rq $BACKPATH/$FILENAME.zip $BACKPATH/$FILENAME.sql
25. echo "erp db backup" | mutt -a $BACKPATH/$FILENAME.zip -s "erp db backup" [email protected]
27. find $BACKPATH -ctime +30 -name *.sql -delete

記得加上--lock-all-tables的參數，這樣在導出sql文件的時候會鎖定表，當然也可以直接把數據庫文件打包。最後加到crontab裡定時運行腳本。