#!/bin/bash

HOST="10.67.0.2"
DATUM=$(date "+%d%m%y")
USER="root"
PASSWORD="<passwort!!!>"

mysqlcheck --user=$USER --password=$PASSWORD --all-databases --auto-repair > /backup/mysql-einstein/mysql_status_$DATUM
mysqldump --user=$USER --password=$PASSWORD --all-databases --opt -l --force | gzip > /backup/mysql-einstein/mysql_$DATUM.sql.gz

databases=$(/usr/bin/mysql --user=$USER --password=$PASSWORD -e 'SHOW DATABASES;' | grep -Ev '(Database|information_schema)')
for db in $databases; do
 /usr/bin/mysqldump -l --opt --hex-blob --force --user=$USER --password=$PASSWORD $db | gzip > /backup/mysql-einstein/db_$db-$DATUM.sql.gz
done

rsync -a /backup/ -e ssh root@$HOST:/daten/sicherung/einstein/backup/
rm /backup/mysql-einstein/*

sync