Re: DBI/DBD::mysql: Detecting InnoDB?

On 11/13/05 4:04 PM, Tyler MacDonald wrote:
> Is there a clean way to detect whether InnoDB support is available
> on the MySQL server? The best I've been able to come up with so far, is
> attempting to create a temporary table with the "TYPE=InnoDB" argument and
> testing to see if it fail

That won't work either. Some (all?) versions of MySQL will silently create
a MyISAM table instead. To find out what really happened, you have to try
to create an InnoDB table and then check the actual table type with a "SHOW
TABLE STATUS FROM ..." query afterwards. That's the only way I've found to
do it, anyway.

-John


.

Relevant Pages