From MyISAM to InnoDB

[Karl_T]

Is it safe to directly change the database engine from MyISAM to InnoDB through some database GUI softwares like Mysql workbench or phpmyadmin?

I have one site installed wrongly with MyISAM engine(Live site, shame...). I want to turn all tables to InnoDB, especially the fields for transaction.

from wire\config.php

/**
 * Database engine
 * 
 * May be 'InnoDB' or 'MyISAM'. Avoid changing this after install.
 * 
 */
$config->dbEngine = 'MyISAM';

[dragan]

I have never done that, but here's the official docs: https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html

With a live site, I would first of all backup the DB, then duplicate the DB and set the copy to InnoDB. Then change the config to point to the new copy. Test as much as you can (frontend, backend - with devmode on and Tracy installed and running). Or even better: make an entire copy of the site too (sub-folder) and test only with that copy first. After first time running the cloned site, clear the modules cache and delete the site/assets/cache folder.