SELECT TABLE_SCHEMA as DbName ,TABLE_NAME as TableName ,ENGINE as Engine
FROM information_schema.TABLES
WHERE ENGINE = 'MyISAM' -- or InnoDB
AND TABLE_SCHEMA NOT IN('mysql','information_schema','performance_schema');