EDIT

#!/bin/sh

#####################################################

#                EDIT THESE SETTING                 #

BACKUPDIR="db_export";

DATABASE="drupal_dataportal"

# the pattern to search for. eg: "my_site_%"

TABLEPATTERN="cdm_cichorieae_node_%";

####################################################

MYSQLDUMP="$(which mysqldump)";

DATEPREFIX="$(date +%Y-%m-%d_%H-%M-%S)";

FILENAME_FPART="$(echo $TABLEPATTERN | sed 's/%//g')";

FILENAME="${DATEPREFIX}_${DATABASE}.${FILENAME_FPART}.sql.gz";

MYSQL=$(which mysql);

#TAR=$(which tar);

GZIP=$(which gzip);

#NICE=$(which nice);

#EGREP=$(which egrep);

echo "will dump all tables matching $TABLEPATTERN from $DATABASE into $FILENAME";

read -p "mysql user:" MYSQL_USR;

read -s -p "mysql password:" MYSQL_PWD;

mkdir -p "$BACKUPDIR";

#echo $MYSQL -u $MYSQL_USR --password="$MYSQL_PWD" -Bse "show tables from $DATABASE LIKE '$TABLEPATTERN'";

TNS=$($MYSQL -u $MYSQL_USR --password="$MYSQL_PWD" -Bse "show tables from $DATABASE LIKE '$TABLEPATTERN'");

echo "\ntables:$TNS"

$MYSQLDUMP -u $MYSQL_USR --password="$MYSQL_PWD" --single-transaction $DATABASE $TNS | $GZIP -c > "$BACKUPDIR/$FILENAME";