#!/bin/bash

umask 022

# paranoia settings
#
PATH=/sbin:/bin:/usr/sbin:/usr/bin
export PATH

TARGET="/backup/database"
mkdir -p "$TARGET"
date=$(/bin/date '+%Y-%m-%d')

## cleanup first
find -name '*.tar.gz' -mtime +14 "$TARGET" -delete

## Backup Database
mysqldump --defaults-extra-file="/opt/redmine/config/database_backup.cnf" "redmine" | gzip > $TARGET/redmine_${date}.sql.gz
done