Check if innodb enabled mysql

To check for innodb support (useful for mysql 3.x only, since 4+ always have innodb) run this bit of sql:

SHOW VARIABLES LIKE 'have_innodb'

Related Scribbles:
  • Convert to Innodb Tips
    		•
  • Databases. MySQL, SQL Server, etc.
    		•
  • Check table type MySQL
    		•

    ID: 626
    Author:
    leonard
    Date Updated:
    2005-05-21 01:01:06
    Date Created:
    2005-05-21 01:01:06

    Edit
    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> Check if innodb enabled mysql
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.