How to find mysql databases/tables, which are stored in innodb engine?
Show tables just list the tables but not tell which are innodb and which are myisam
try
SELECT ENGINE FROM information_schema.TABLES
