#!/bin/bash
#

NBDIRTOKEEP="3"

date=$(date "+%Y-%m-%d")
path_backup="/var/backups/mysql"

if [ -f /etc/mysql/failover_ip ]
then
    FAILOVER="$(cat /etc/mysql/failover_ip)"
    ip addr show | grep -qF "$FAILOVER"
    if [ $? -eq 0 ]
    then
        echo "No mysql backup cause we're on failover"
        exit 1
    fi
fi


mkdir -p $path_backup/$date/
cd $path_backup/

MD=""

EXCLUDE=""

getexcluded() {
    cat /etc/mysql/dump.split | grep -v "^#" |grep "\." | while read DBTABLE
    do
	echo -n "--ignore-table=$DBTABLE "
    done
}

if [ -r "/etc/mysql/dump.split" ]
then
    EXCLUDE=$(getexcluded)
fi

for database in $(mysql --defaults-file=/etc/mysql/debian.cnf -Bs \
                        -e "show databases"|grep -v "^performance_schema$"|grep -v "^information_schema$")
do
    # echo $database;
    mysqldump --defaults-file=/etc/mysql/debian.cnf --skip-opt \
	      $MD --force --routines \
              --add-drop-table --create-options --disable-keys \
              --extended-insert --quick --set-charset $database \
	      --events --skip-lock-tables $EXCLUDE \
              | nice pbzip2 > $date/$database.sql.bz2
done


if [ -r "/etc/mysql/dump.split" ]
then
    # Now dumping separate tables :
    cat /etc/mysql/dump.split | grep -v "^#" |grep "\." | while read DBTABLE
    do
	DB=$(echo $DBTABLE |sed -e 's/\..*$//')
	TABLE=$(echo $DBTABLE |sed -e 's/^.*\.//')
	mysqldump --defaults-file=/etc/mysql/debian.cnf --skip-opt \
	    $MD --force \
            --add-drop-table --create-options --disable-keys \
            --extended-insert --quick --set-charset "$DB" "$TABLE" \
	    --events --skip-lock-tables \
            | nice pbzip2 > $date/${DB}.${TABLE}.sql.bz2
	if [ "$?" = "2" ]
	then
	    echo "table not found, removing useless dumpfile"
	    rm -f "$date/${DB}.${TABLE}.sql.gz"
	fi
    done
fi

cd $path_backup/ && [ "$(ls $path_backup/ -1rt | head -n -$NBDIRTOKEEP | wc -l)" != '0' ] && for this_dir in $(ls $path_backup/ -1rt | head -n -$NBDIRTOKEEP) ; do [ -d "$path_backup/$this_dir" ] && rm -rf "$path_backup/$this_dir" ; done

# EOF
