#Backup Redmine Server
# - backup mysql databases
# - backup Redmine/files
# - backup Redmine/config
# - copy to shared folder

#!/bin/bash
### MySQL Server Login Info ###
MUSER="root"
MPASS="mysql4all!"
MHOST="localhost"
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
### Backup config
TODAY=$(date +"%d-%m-%Y")
HOSTNAME=$(hostname -s)
BACKUPDIRECTORY="/backup"
BACKUPFILE="$HOSTNAME-$TODAY.tg.gz"
NUMBEROFDAYSTOKEEPBACKUP=7
GZIP="$(which gzip)"
### What to backup?
BACKUPDIRS="/var/www/config /var/www/files"

[ ! -d $BACKUPDIRECTORY ] && mkdir -p $BACKUPDIRECTORY || /bin/rm -rf $BACKUPDIRECTORY/*
mkdir -p $BACKUPDIRECTORY/mysql/
DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
for db in $DBS
do
 FILE=$BACKUPDIRECTORY/mysql/$db.$TODAY-$(date +"%T").sql
 $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db --single-transaction > $FILE
done
tar czf $BACKUPDIRECTORY/$BACKUPFILE $BACKUPDIRS $BACKUPDIRECTORY/mysql/
/bin/rm -rf $BACKUPDIRECTORY/mysql/
mount -t cifs //swbdevsrv04.soreco.wan/Redmine /media/Redmine -o username=sk,password=stock66,iocharset=utf8,file_mode=0777,dir_mode=0777
find /media/Redmine -mtime +$NUMBEROFDAYSTOKEEPBACKUP -type f -exec rm -rf {} \;
cp $BACKUPDIRECTORY/$BACKUPFILE /media/Redmine/$BACKUPFILE
umount /media/Redmine