Automatically back up redmine installation

required settings
DB_USERNAME=’‘
DB_PASSWORD=’‘
DB_NAME=’‘
REDMINE_ROOT=’’ # e.g. /home/peter/rails/redmine.commanigy.com’
BACKUP_ROOT=’’ # e.g. /home/peter/backups (will be created)

# optional settings
GS_ROOT=’gs://redmine-backup’
GS_FILENAME=’backup_‘date +%Y%m%d‘.tar.gz’

echo ‘Setting up directories’
mkdir $BACKUP_ROOT/redmine/db -p
mkdir $BACKUP_ROOT/redmine/files -p

echo ‘Backing up database’
/usr/bin/mysqldump -u $DB_USERNAME –password=$DB_PASSWORD $DB_NAME | gzip > $BACKUP_ROOT/redmine/db/date +%Y%m%d.gz

echo ‘Backing up attachments’
rsync -a $REDMINE_ROOT/files/ $BACKUP_ROOT/redmine/files/

echo ‘Packing into single archive’
tar -czPf $GS_FILENAME $BACKUP_ROOT/redmine/

echo ‘Creating bucket on Google Storage (if not already created)’
gsutil mb $GS_ROOT

echo ‘Copying backup archive to Google Storage’
gsutil cp $GS_FILENAME $GS_ROOT

echo ‘Cleanup by removing archive’
rm $GS_FILENAME

echo ‘Backup complete’