#!/bin/bash
USER=root
PASSWD='pass'
# Datum
NOW=`date +%a-%d-%m-%Y`
BACKUPDIR=/root/sqlbackup

echo "Alle MySQL-Datenbanken sichern:"
# Bereinigte Liste der Datenbanken erzeugen
/usr/bin/mysqlshow -u$USER -p$PASSWD | awk '{print $2}' | grep -v Databases | sort >./dbaselist

if [ -d $BACKUPDIR ]; then
mkdir -p $BACKUPDIR
fi

for x in `cat ./dbaselist`; do
    echo "Datenbank: $x sichern";
    /usr/bin/mysqldump --opt -u$USER -p$PASSWD $x > $BACKUPDIR/$x.sql;
    cd $BACKUPDIR || exit 1
    echo "$x.sql.tar.gz erstellen"
    tar -czf $BACKUPDIR/$x.sql.tar.gz $BACKUPDIR/$x.sql -C $BACKUPDIR;

done;