#!/bin/bash
sqluser="root"
sqlpw="DEINPWHIER"
date=$(date +%Y%m%d-%H%M)
mailfrom="sqlbackup@DEINEDOMAIN.HIER"
mailto="DEINE.EMPFÄNGERE@EMAIL.HIER"
tlson="tls=YES"
databases=$(mysql --user="$sqluser" --password="$sqlpw" -e "SHOW databases" | sed 's/|/s.+/p' | sed "1d")
for database in $databases
do
    echo "$date - Create dump for $database >> /backup/sqldump/$database-$date.sql";
    mysqldump --user="$sqluser" --password="$sqlpw" --complete-insert --create-option --log-error="/var/log/sqldump.log" $database > /backup/sqldump/$database-$date.sql;
    if [ $? = "1" ]; then
	sendEmail -f $mailfrom -t $mailto -o $tlson -u "Error creating Database Backup from $database" -a /var/log/sqldump.log -m "
Dear Administrator,

A problem was occurred with database "$database".
For mor information look at attachment file "sqldump.log".

Greetings

DEINEDOMAIN.DE - Servermessage"
     else
	sendEmail -f $mailfrom -t $mailto -o $tlson -u "Created Database Backup from $database" -a "/var/log/sqldump.log" -a "/backup/sqldump/$database-$date.sql" -m "
Dear Administrator,

This is a status mail from database-backup-script.
The backup was created: /backup/mysqldump/$database-$date.sql
Logfile: 		/var/log/sqldump.log

Have a nice day

DEINEDOMAIN.DE Servermessage"
      fi
done