Since I always forget stuff like this. This is the SQL query to detect mysql table schemas type (thanks to Darren.B) :

SELECT table_name, table_schema, table_type, engine FROM information_schema.tables where table_schema not in ('information_schema', 'mysql');