Mysqldump data from database tables matching a pattern

mysqldump_bypattern.sh

#!/bin/bash

if [ $# -lt 5 ]; then
  echo "Exports data from mysql database in tables matching a like pattern e.g. 'table_%'"
  echo "Usage: $0 dbname dbuser dbpass pattern outputfile"
  exit 1
fi

DBNAME=$1
DBUSER=$2
DBPASS=$3
PATTERN=$4
OUTPUTFILE=$5

TABLES=( `mysql -u$DBUSER -p$DBPASS $DBNAME --silent -e "show tables like '$PATTERN'"` )

for TABLE in "${TABLES[@]}"; do
  mysqldump -u$DBUSER -p$DBPASS $DBNAME $TABLE >> $OUTPUTFILE
done