mariadb backups while

backup_server=192.168.0.24
backup_user=admin

intento=1
maximo_intentos=3

destino="/root/mariadb"
mkdir -p "$destino"

backup_mariadb() {

    bases=($(mysql -N -e "SHOW DATABASES;" | \
    grep -Ev '^(information_schema|performance_schema|mysql|sys)$'))

    for db in "${bases[@]}"
    do
        echo "Respaldando: $db"

        mysqldump "$db" > "${destino}/${db}.sql"
	gzip "${destino}/${db}.sql"
    done
}


respaldar() {

	rsync -av $destino/ ${backup_user}@${backup_server}:/home/admin/mariadb



}



backup_mariadb



while [ $intento -le $maximo_intentos ];do

	echo Intento $intento

	ping -c 1 $backup_server > /dev/null 2>&1 && respaldar \
		|| intento=$((intento+1))

	[ $intento -eq $maximo_intentos ] && echo No se pudo establecer conexion con e lservidor, se mantiene backup local.
done