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

From: pablo@xxxxxxxxxxxx (Paul Fierro)
Date: Mon, 14 Nov 2005 09:33:55 -0600

On 11/13/2005 3:04 PM, Tyler MacDonald <tyler@xxxxxx> 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 fails, but if there is just some flag I can query the
> database with I would much rather use that.

For MySQL >= 4.1.2 you can use 'show engines':

http://dev.mysql.com/doc/refman/4.1/en/show-engines.html

Paul

.

References:
- DBI/DBD::mysql: Detecting InnoDB?
  - From: Tyler MacDonald

Prev by Date: Re: Why no [dbi-users] in subject
Next by Date: error installing Bundle::DBD::mysql 3.0002
Previous by thread: Re: DBI/DBD::mysql: Detecting InnoDB?
Next by thread: DBD::Oracle won't install for Oracle 10G XE
Index(es):
- Date
- Thread