Shell Programming and Scripting

#!/bin/sh


#ATTENTION! this script MIGHT NOT work for database names with blanks!!! (tables work fine)

BACKUPDIR="/media/DBSaves/Backup";
DBFILTER="(database_x|database_y)";
MYSQLDUMP="$(which mysqldump) --opt";

MYSQL=$(which mysql);
GZIP=$(which pbzip2);
NICE=$(which nice);
EGREP=$(which egrep);

DBS=$($MYSQL -Bse "show databases");

for db in $DBS
do

    if (echo $db | $EGREP $DBFILTER > /dev/null);
    then
      # for import to $TBL blanks in table names are replaced by '@' otherways the tablename would be split by the blank.
      # The '@' is replaced 4 lines later again otherways mysqldump can not find the table
      # IF YOU USE '@' in table names - replace it in the sed-commands with your favourite string ;)
      TBL=$($MYSQL -Bse "show tables from $db" | sed s/\ /@/g);

      for tb in $TBL
      do
         TableNameKorr=`echo $tb | sed s/@/\ /g;`
         FILENAME="$db""_""$tb-`date +%Y%m%d_%H%M%S`.sql.gz";
         UseAnweisung="CREATE DATABASE  IF NOT EXISTS \`$db\` /*!40100 DEFAULT CHARACTER SET latin1 */;USE \`$db\`;"
         {
            $NICE -n 20 printf '%s\n' "$UseAnweisung"
            $NICE -n 20 $MYSQLDUMP "$db" "$TableNameKorr"
            } |
              $NICE -n 20 $GZIP -c > "$BACKUPDIR/$FILENAME"
      done

    fi

done

exit 0