#!/bin/bash

# MariaBD/MySQL remote
#
# The Information what MySQL/MariaDB - databases should be backuped are defined in ~/.my.cnf
#
# note:for MARIADB in $(ls .my.cnf-* | cut -d "-" -f2); do mysqldump --defaults-file="~/.my.cnf-$MARIADB" --skip-dump-date $MARIADB > $TMP_DIR/$(cat ~/.my.cnf-$DATABASE | grep host | cut -d "=" -f2); done
# note: for each MySQL- or MariaDB-Database create a seperate configfile .my.cnf-dbname ind the ~ of the backupuser:
# note: replase the suffixe -dbname with the name of the database. The seperating "-" can also be a ".".
#	[mysqldump]
# host=HOSTNAME
# user=DBUSERNAME
# password=PASSWORD
# database=DATABASENAME

function check-mariadb-deps {
	if [ ! -e /usr/bin/mysqldump ]; then
		debug "It seems that you dont have mysqldump installed. You may have problems to backup remote databases"
	fi
# TODO: Check for ~/.my.cnf-*
}

function mariadb_remote {
	for MARIADB in $(ls ~/.my.cnf-* | cut -d "-" -f2); do
		debug "Function mariadb_remote: Doing Database: $MARIADB"
		MARIADBHOSTNAME=$(cat ~/.my.cnf-"$MARIADB" | grep host | cut -d "=" -f2)
		/usr/bin/mysqldump --defaults-file=~/.my.cnf-"$MARIADB" --skip-dump-date "$MARIADB" > "$TMP_DIR"/"$MARIADBHOSTNAME"_"$MARIADB".mysql
		debug "Diff MySQLDump $MYSQLDB"
		diff "$TMP_DIR"/"$MARIADBHOSTNAME"_"$MARIADB".mysql "$BACKUP_DIR"/"$MARIADBHOSTNAME"_"$MARIADB".mysql > /dev/null 2>&1
	if [ $? -ne 0 ]; then
		debug "Differences found -> moving to BACKUP_DIR"
		backup_file_handler "$TMP_DIR" "$BACKUP_DIR" "$MARIADBHOSTNAME"_"$MARIADB".mysql
	else
	        debug "No differences found in Database $MARIADB"
	fi
	echo ""
	done
}

function mariadb-main {
	if [ "$MARIADB_BACKUP_REMOTE" = "TRUE" ]; then
		mariadb_remote
	fi
}