Mantis 資料庫的備份 script
由於公司產品在 RD 端及我們 DQA 都需要有 bug tracking 的工具,好讓大家工作更緊密更能即時將我們找到的 bug
讓 RD 去解,所以在之前我就已經幫公司架了一台 mantis 來負責這份 bug tracking 的工作,當時也寫了一個簡單的 script
做資料庫的備份以防這台掛了隨時復原回來會比較容易~~ 
不過這個 script 是我隨手弄的所以還滿爛的,如果有問題的話請自行修改,我想對於懂得寫 shell 的人應該很簡單,
下面就是我備份 Mantis Database 的 script 大家可以參考一下依自己環境再做修改
#!/bin/sh
today=`/bin/date +%Y%m%d`
deldate=`/bin/date -v -7d +%Y%m%d`
host_ftp=”192.168.234.44″
data1=mantis-backup-db_$today.tgz
data2=mantis-backup-web_$today.tgz
data3=mantis-backup-uploadfiles_$today.tgz
data4=mantis-backup_$today.sql
user=”sqa”
password=”SQAsqa”
/usr/local/etc/rc.d/mysql-server.sh stop
/usr/local/etc/rc.d/apache.sh stop
cd /var/db/mysql
tar -zcvf /root/mantis-backup/mantis-backup-db_$today.tgz mantis
cd /usr/local/www/data
tar -zcvf /root/mantis-backup/mantis-backup-web_$today.tgz mantis
cd /var/
tar -zcvf /root/mantis-backup/mantis-backup-uploadfiles_$today.tgz upload_files
/usr/local/etc/rc.d/mysql-server.sh start
/usr/local/etc/rc.d/apache.sh start
mysqldump mantis -u root –password=SQAsqa –opt > /root/mantis-backup/mantis-backup_$today.sql
ftp -in << EOF
open $host_ftp
user $user $password
bin
cd Mantis-backup
lcd /root/mantis-backup
put $data1
put $data2
put $data3
put $data4
bye
EOF
#
echo ‘———- Begin delete data 7 days ago ———-’
rm -f /root/mantis-backup/mantis-backup-web_$deldate.tgz
rm -f /root/mantis-backup/mantis-backup-db_$deldate.tgz
rm -f /root/mantis-backup/mantis-backup-uploadfiles_$deldate.tgz
rm -f /root/mantis-backup/mantis-backup_$deldate.sql
ls -al /root/mantis*
