Change all tables from all databases MyISAM to InnoDB

SELECT CONCAT('USE ', table_schema, ';  ALTER TABLE ', table_name, ' ENGINE=InnoDB;')
FROM  information_schema.tables
WHERE  engine = 'MyISAM'
  AND  table_schema NOT IN ('mysql', 'information_schema', 'performance_schema');

source http://mysql.rjweb.org/doc.php/myisam2innodb

Laisser un commentaire