Linux上備份Oracle數(shù)據(jù)庫腳本
# exp-backup.sh# initialize oracle database env variable /home/oracle/oraenv# assign current date to variable rq# 注意：定義rq變量用的單引號是tab鍵上面的~鍵。 rq=`date +"%y%m%d"`# export whole database exp expuser/web2dump5@ctgpcweb parfile=./export.par file=/backup/db_1634_$rq.dmp log=./db_1634_$rq.log
會發(fā)送和抄送郵件的MySQL數(shù)據(jù)庫備份腳本
backupDB_then_mail_it.sh
#!/bin/bash
echo Delete last arthive file\(s\) ...
rm DB_BACKUP.sql.gz
echo Backup MySQL DB\(c156948_wbj123Drupal\) ...
mysqldump --user=c156948admin --password=xxxxxxx --host=mysql4-c c156948_wbj123Drupal | gzip > DB_BACKUP.sql.gz
echo Mail it to xxxxxx@gmail.com ...
uuencode DB_BACKUP.sql.gz DB_BACKUP.sql.gz | mail -s "Drupal DB BACKUP of wbj123.com" -c xxxxxxx@shtel.net.cn xxxxxx@gmail.com
解釋如下：
先刪掉上次備份的舊的備份文件
再備份MySQL數(shù)據(jù)庫
再把數(shù)據(jù)庫的備份文件Email到兩個郵箱中
若不要抄送郵件，就改用下面這段
echo Mail it to xxx@yyyyyy.com with short title ...
uuencode DB_BACKUP.sql.gz DB.gz | mail -s "DB" xxx@yyyyyy.com