• Remplacer your_database par le nom de votre base de donnĂ©es :
SELECT CONCAT('ALTER TABLE ',CONCAT(TABLE_SCHEMA,'.',TABLE_NAME),'     
ENGINE=InnoDB;') 
FROM INFORMATION_SCHEMA.TABLES
WHERE ENGINE='MyISAM'
AND TABLE_SCHEMA = 'your_database'
INTO OUTFILE '/tmp/mysql.conversions';
  • VĂ©rifier le contenu de /tmp/mysql.conversions et on le joue :
SOURCE /tmp/mysql.conversions;