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
