Redmine

#!/bin/dash

NOW=`date +'%Y.%m.%d %T'`

echo $NOW' Start'

DB_USERNAME='<USERNAME>'

DB_PASSWORD='<PASSWORD>'

DB_NAME='redmine_production'

REDMINE_ROOT='/var/www/redmine'

BACKUP_ROOT='/var/backups'

BACKUP_ROOT_REDMINE=$BACKUP_ROOT/redmine

BACKUP_ROOT_REDMINE_TMP=$BACKUP_ROOT/redmine/tmp

GS_FILENAME='redmine_full_backup_'`date +%Y%m%d`'.tar.gz'

NOW=`date +'%Y.%m.%d %T'`

#echo $NOW' Setting up directories'

mkdir $BACKUP_ROOT -p

mkdir $BACKUP_ROOT_REDMINE -p

rm -rf $BACKUP_ROOT_REDMINE_TMP/db

mkdir $BACKUP_ROOT_REDMINE_TMP/db -p

rm -rf $BACKUP_ROOT_REDMINE_TMP/files

mkdir $BACKUP_ROOT_REDMINE_TMP/files -p

mkdir $BACKUP_ROOT_REDMINE/full -p

NOW=`date +'%Y.%m.%d %T'`

echo $NOW' Backing up database'

/usr/bin/mysqldump -u $DB_USERNAME --password=$DB_PASSWORD $DB_NAME | gzip > $BACKUP_ROOT_REDMINE_TMP/db/mysql_`date +%Y%m%d`.sql.gz

NOW=`date +'%Y.%m.%d %T'`

echo $NOW' Backing up attachments'

rsync -a $REDMINE_ROOT/files/ $BACKUP_ROOT_REDMINE_TMP/files/

NOW=`date +'%Y.%m.%d %T'`

echo $NOW' Packing into single archive'

#tar -czPf $BACKUP_ROOT_REDMINE/$GS_FILENAME $BACKUP_ROOT_REDMINE_TMP

cd $BACKUP_ROOT_REDMINE_TMP

tar -czf $BACKUP_ROOT_REDMINE/full/$GS_FILENAME ./

NOW=`date +'%Y.%m.%d %T'`

echo $NOW' rsync to windows file server'

rsync -avz $BACKUP_ROOT_REDMINE/full/ /mnt/backupshare/redmine/

NOW=`date +'%Y.%m.%d %T'`

echo $NOW' Backup end'