Hello,

for a module i'm developing, i'd like to use InnoDB Tables (Transaction Support is the main reason).
Writing the Module is not the issue, but the SQL Scripts obviously contain the "ENGINE = InnoDB" statement that will fail if you run an older MySQL without InnoDB Support.

What would be a good way to check whether the DB Server supports InnoDB and gracefully exit if not? (This check should happen upon installation of the module)

The Xoops Info module retrieve informations from php.ini.

Look this code and adapt this for verify if innodb is supported.

with a simple query..

SHOW VARIABLES LIKE '%have_innodb%';