Pour afficher la liste de toutes les tables encore stockées en MyISAM, il faut utiliser la requête : SELECT TABLE_SCHEMA as DbName ,TABLE_NAME as TableName ,ENGINE as Engine FROM information_schema.TABLES WHERE ENGINE='MyISAM' AND TABLE_SCHEMA NOT IN('mysql','information_schema','performance_schema');

Il est possible de demander la migration vers InnoDB :
Se connecter avec l'option "-s" : mysql -u root -p -s, lancer :
SELECT CONCAT('ALTER TABLE `', TABLE_SCHEMA,'`.`',TABLE_NAME, '` ENGINE = InnoDB;') FROM information_schema.TABLES WHERE ENGINE='MyISAM' AND TABLE_SCHEMA NOT IN('mysql','information_schema','performance_schema');
et copier coller.

Source : https://dba.stackexchange.com/a/50030/41202