Untitled

SQL_STRING=""
DB_HOST=
for database in $(mysql -u root -h $DB_HOST -p -A -N -B -e "SHOW DATABASES")
do
    echo -e "DATABASE: $database"
    for table in $(mysql -u root -h $DB_HOST -p -A -N -B -e "SHOW TABLES" $database)
    do
        SHOW="SHOW TABLE STATUS IN $database LIKE '$table';"; SQL_STRING=$SQL_STRING$SHOW
        echo -e $SQL_STRING
    done
done
mysql -u root -h $DB_HOST -p -A -N -B -e "$SQL_STRING"