#!/bin/sh

set $(date)
str_Tag=$(date +%A);
BACKUP_DIR="/backup/"
MYSQL_PWD="tatort36stoff"

 echo "creating mysql dump"

 echo -n "   creating directories"
   rm -rf $BACKUP_DIR/mysql
   mkdir -p $BACKUP_DIR/mysql
 echo -e "\033[40;1;32m OK \033[0m"

 echo -n "   create mysql dump"
   DBASELIST=`mktemp`
   mysqlshow -p$MYSQL_PWD | awk '{print $2}' | grep -v Databases | sort >$DBASELIST

    for x in `cat $DBASELIST`; do
       echo "    saving database: $x";
       mysqldump -A --add-locks -u root --opt -p$MYSQL_PWD $x >$BACKUP_DIR/mysql/$x.sql;
       tar cfvz $BACKUP_DIR/$6.$3.$2_$x.tar.gz $BACKUP_DIR/mysql/$x.sql > /dev/null 2>&1
   done;
 echo -e "\033[40;1;32m OK \033[0m"

 echo -n "   cleaning up"
   rm -r $BACKUP_DIR/mysql
 echo -e "\033[40;1;32m OK \033[0"