#/bin/bash

USR='root'
PWD='password'

for TABLENAME in `mysql -u ${USR} -p${PWD} -N -s -e "SELECT concat(TABLE_SCHEMA,\".\",TABLE_NAME) as TABLE NAME FROM information_schema.tables WHERE TABLE_SCHEMA like 'PREFIX_%' AND TABLE_TYPE = 'BASE TABLE' AND ENGINE = 'InnoDB';"`;
do
    mysql -u ${USR} -p${PWD} -N -s -e "SELECT * FROM $TABLENAME;" > /dev/null
done;

###
### -N: カラム名を出力しない
### -s: セパレータをタブに置換
###