backup redmine

backup_redmine

#!/bin/sh

### SETTINGS ################################################
DB_NAME=agileware_redmine
DB_USER=root
DB_HOST=localhost

BACKUP_ROOT=/backups

APP_NAME=agileware-redmine
APP_ROOT=/var/rails/$APP_NAME/shared
BACKUP_SOURCE_DIR=files

PERIOD=30
#############################################################

# FILE BACKUP
BACKUP_DEST=$BACKUP_ROOT/files
mkdir -p $BACKUP_DEST

cd $APP_ROOT
tar -czf ${BACKUP_DEST}/`date +%Y%m%d`.files.tar.gz ${BACKUP_SOURCE_DIR} 1> /dev/null;

oldfile=`date --date "$PERIOD days ago" +%Y%m%d`
rm -f $BACKUP_DEST/$oldfile.files.tar.gz

# DB BACKUP
BACKUP_DEST=$BACKUP_ROOT/db
mkdir -p $BACKUP_DEST
mysqldump --opt --user=$DB_USER --host=$DB_HOST $DB_NAME > $BACKUP_DEST/`date +%Y%m%d`.$DB_NAME.dump.sql

oldfile=`date --date "$PERIOD days ago" +%Y%m%d`
rm -f $BACKUP_DEST/$oldfile.$DB_NAME.dump.sql