#!/bin/bash

function do_backup(){
   FICHERO_BACKUP=$1
   # Do the backup
   $MYSQL_PATH/mysqldump -p"$password" \
                         --add-drop-table \
                         -h "$hostname" \
                         -u "$username" \
                         "$database" \
       | $BIN_PATH/bzip2 -c > "$FICHERO_BACKUP"
}

BASEDIR=$(dirname $0)
BACKUPDIR=/private/backup
DBCONFIG=$BASEDIR/dbconfig.ini

test -f "$DBCONFIG" && source "$DBCONFIG"

if [ -z "$database" ]; then
  echo "error: Configuration file not found '$DBCONFIG'"
  exit 0
fi


EMAILTO="email@example.com"
BIN_PATH=/bin
MYSQL_PATH=/usr/bin

DIA=`$BIN_PATH/date -I`
FECHA=`$BIN_PATH/date +%Y-%m-%d_%H-%M`

FICHERO_BACKUP=$BACKUPDIR/dbdump-$FECHA.sql.bz2

cd "$BASEDIR"
do_backup "$FICHERO_BACKUP"

# Send by email
./send-email-attachment.pl "$EMAILTO" "$FICHERO_BACKUP" "$FECHA" "application/zip"