How to check if MySQL table is UTF-8 and has storageEngine InnoDB?
You can use information_schema in order to know the engine of each table.
select table_name,engine from information_schema.tableswhere table_schema = 'your_database'For the encoding you can use
show create table table_nameor, even better
select c.character_set_name from information_schema.tables as t, information_schema.collation_character_set_applicability as cwhere c.collation_name = t.table_collationand t.table_schema = "your_db"and t.table_name = "table_name";