aC forum: How to tell if MySQL has InnoDB support enabled? http://www.activecollab.com/forums/topic/571/ Recent posts on topic: How to tell if MySQL has InnoDB support enabled? en-us Sun, 23 Nov 2008 11:37:18 UTC http://www.activecollab.com/forums/post/2746/#post2746 http://www.activecollab.com/forums/post/2746/#post2746 Post #1 by Ilija Studen Ilija Studen Q: How to tell if MySQL has InnoDB support enabled?

A: Run this query (in phpMyAdmin, mysql console tool or whatever MySQL administration tool you have):

SHOW VARIABLES LIKE 'have_innodb';

It should return something like this:

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb   | YES   |
+---------------+-------+

]]> Tue, 05 Sep 2006 11:11:31 UTC