redmine 自動備份

任務: 每周自動備份 redmine server 上的重要資料到另台samba server.

redmine 主機; 192.168.1.201, ubuntu 64, 12.04

samba 主機: 192.168.1.202

將shell script redmineback.sh 

#!/bin/sh
#place to store redmine files
LOCAL_PATH=/var/backups/redmine
#redmine database password
PASSWORD=
  
  
   
   
#redmine database user name
USER=redmine
#redmine database name
DATABASE=redmine
#log name to keep backup record
LOG_FILE=${LOCAL_PATH}/${DATABASE}_backup.log
#compressed redmine database name
TARGET_FILE=${DATABASE}_`date +%y_%m_%d`.gz
#tar file to compress everything
TAR_DIR=/var/backups
TAR_SOURCE=redmine`date +%Y%m%d`.tar.gz
TAR_PATH=${TAR_DIR}/${TAR_SOURCE}
#remote samba server
SERVER=//
   
   
    
    /redmine_backup
#folder to store the backup tar file
REMOTE_FOLDER=
    
    
     
     

echo `date +%Y/%m/%d_%T`: ${TARGET_FILE}>> ${LOG_FILE}
mysqldump -u${USER} -p${PASSWORD} ${DATABASE} | gzip > ${LOCAL_PATH}/${TARGET_FILE}
echo `ls ${LOCAL_PATH}/${TARGET_FILE} -la` >> ${LOG_FILE}
rsync -a /var/redmine/files ${LOCAL_PATH}/files
rsync -a /usr/local/share/redmine/config/*.yml ${LOCAL_PATH}/files/config/.
tar -czf ${TAR_PATH} ${LOCAL_PATH}
echo `ls ${TAR_PATH} -la` >> ${LOG_FILE}
smbclient ${SERVER} -U
     
      
      
      
        -c "lcd ${TAR_DIR};cd ${REMOTE_FOLDER} ;put ${TAR_SOURCE};exit;" >>${LOG_FILE} rm ${TAR_PATH} 
      
     
     
    
    
   
   
  
  

複製到 /etc/cron.weekly 目錄下

運作原理:

將資料庫取出及備份:

mysqldump -u${USER} -p${PASSWORD} ${DATABASE} | gzip > ${LOCAL_PATH}/${TARGET_FILE}

將redmine 附件檔案夾內容及設定檔備份

 
 

  
  rsync -a /var/redmine/files 
  
  ${
  
  LOCAL_PATH
  
  }/files
 
 
 
 

  
  rsync -a /usr/local/share/redmine/config/*.yml 
  
  ${
  
  LOCAL_PATH
  
  }/files/config/.
 
 

將所有檔案壓成一份

tar -czf ${TAR_PATH} ${LOCAL_PATH}

傳到samba server

smbclient ${SERVER} -U<user_name> <password> -c "lcd ${TAR_DIR};cd ${REMOTE_FOLDER} ;put ${TAR_SOURCE};exit;" >>${LOG_FILE}

刪除本地的tar 檔

rm ${TAR_PATH}