On 11/13/2005 3:04 PM, Tyler MacDonald <[EMAIL PROTECTED]> 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
