Find which tables use INNODB
The SQL to do this queries the INFORMATION_SCHEMA and is as follows: SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = ‘innodb’; where: table_schema is the name of the database. table_name is (obviously) the name of the table.