mysql utility.

mysql_table_engine.bash

#!/bin/bash

MYSQL_DB="$1”
MYSQL_HOST=“${2:-localhost}”
MYSQL_PASS="${3:-password}"

mysql -u root -p${MYSQL_PASS} -h ${MYSQL_HOST} -s ${MYSQL_DB} -e "show tables;" | grep -v Tables_in_ | while read line; do
    echo "== ${MYSQL_DB}.${line} ============================================================================="
    mysql -u root -p${MYSQL_PASS} -h ${MYSQL_HOST} -s ${MYSQL_DB} -e "show create table ${MYSQL_DB}.${line};" | grep ENGINE | grep -v 'ENGINE=InnoDB'
done