#!/bin/bash
suffix=$(date -d 'today' +%Y-%m-%dT%H:%M)
tmpdir=$(mktemp -d)
sql_file="mariadb-$suffix.sql"

echo "Dumping MySQL database from host $SQL_HOSTNAME into file $sql_file"
mariadb-dump --host="$SQL_HOSTNAME" --user="$SQL_USERNAME" --password="$SQL_PASSWORD" -x --all-databases > "$tmpdir"/"$sql_file" || exit 1

echo "Sending backup to ${BCK_USERNAME}@${BCK_HOSTNAME}"
scp -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -i /root/.ssh/id_rsa "$tmpdir"/"$sql_file" "$BCK_USERNAME"@"$BCK_HOSTNAME":"$BCK_FOLDER"/$sql_file || exit 2