#!/bin/bash

STORAGE=$1
NOW=$(date +"%d-%m-%Y_%H%M%S")
BACKUP=$STORAGE/daily_$NOW
MUSER="ezp"
MPASS="publish"
MHOST="10.29.47.121"
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
FIND="$(which find)"
RM="$(which rm)"
GZIP="$(which gzip)"
IGGY="test mysql phpmyadmin ez"

### Remove old backups
$FIND $STORAGE -maxdepth 1 -name 'daily*' -type d -mtime +1 -exec $RM -r {} \;

### Start Backup for file system ###
[ ! -d $BACKUP ] && mkdir -p $BACKUP || :

### MySQL Backup ###
DBS="$($MYSQL -u $MUSER -p$MPASS -h $MHOST -Bse 'show databases')"
for db in $DBS
do
 skipdb=-1
 if [ "$IGGY" != "" ];
 then
 for i in $IGGY
 do
  [ "$db" == "$i" ] && skipdb=1 || :
 done
 fi
 if [ "$skipdb" == "-1" ] ; then
  FILE=$BACKUP/mysql-$db.$NOW.sql.gz
  $MYSQLDUMP -u $MUSER -p$MPASS -h $MHOST $db --ignore-table=$db.ezsession --skip-lock-tables | $GZIP -9 > $FILE
 fi
done