Redmine

#!/bin/bash

# !ensure that this file cannot be read by others, only by root,

# as it contains redmine database credentials!

DATE=`date +"%Y%m%d"`

BACKUP_DIR=/var/backup/redmine

DB_USER="redmine"

DB_PASS="your_password"

REDMINE_HOME=/var/redmine

DB_CHARSET=utf8

# delete old backups

find $BACKUP_DIR -maxdepth 1 -type d -mtime +62 -exec rm -rf {} \;

# create backup dir

mkdir -p $BACKUP_DIR/$DATE

# backup db

mysqldump -u $DB_USER -p${DB_PASS} --single-transaction --default-character-set=${DB_CHARSET} redmine | gzip > $BACKUP_DIR/${DATE}/mysql.gz

# backup redmine

tar -pzcf $BACKUP_DIR/${DATE}/redmine.tar.gz -C $REDMINE_HOME .