Query to determine "engine type" of a table?

MySQL release: 4.1.14

The web hosting provider that I am currently stuck with (Yahoo) does
not allow shell access, only myPhpAdmin. They also say that they don't
allow InnoDB tables, just MyISAM. I created a table in MyISAM (the
only choice in this set-up) and then ran this SQL command:

alter table zip3 engine = innodb;

....and got a message that the command completed successfully, but when
I look at the table via myPhpAdmin I see that it's the same size, and I
know that InnoDB tables are (according to an article I read at
mysql.com), at least three times (3x) larger.

myPhpAdmin still lists the type as MyISAM, but InnoDB isn't even one of
the choices.

A MyISAM table won't cut it for this app I'm writing. --> Does anyone
know of A BETTER WEB HOSTING SERVICE? (I'll switch today!) I'm an
Oracle jock who would be quite content if only I could make one InnoDB
table.

I'm all ears for *any* input you have on any of the above. Thanks in
advance!

workingstiff19@hotmail.com wrote:
> MySQL release: 4.1.14
>
> The web hosting provider that I am currently stuck with (Yahoo) does
> not allow shell access, only myPhpAdmin. They also say that they don't
> allow InnoDB tables, just MyISAM. I created a table in MyISAM (the
> only choice in this set-up) and then ran this SQL command:
>
> alter table zip3 engine = innodb;
>
> ...and got a message that the command completed successfully, but when
> I look at the table via myPhpAdmin I see that it's the same size, and I
> know that InnoDB tables are (according to an article I read at
> mysql.com), at least three times (3x) larger.
>
> myPhpAdmin still lists the type as MyISAM, but InnoDB isn't even one of
> the choices.
>
> A MyISAM table won't cut it for this app I'm writing. --> Does anyone
> know of A BETTER WEB HOSTING SERVICE? (I'll switch today!) I'm an
> Oracle jock who would be quite content if only I could make one InnoDB
> table.
>
> I'm all ears for *any* input you have on any of the above. Thanks in
> advance!
>

There are hundreds of better web hosting services. Try asking in
alt.www.webmaster.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================