or by setting the default-storage-engine option in the my.cnf configuration file. You may also want to change the default storage engine just for the current session. You can do this by setting the st - Eduguru

How to convert all tables from MyISAM into InnoDB?

August 2, 2014 eduguru 0 Comments but you can change it by using the --default-storage-engine server startup option, How to convert all tables from MyISAM into InnoDB?, If you omit the ENGINE option, or by setting the default-storage-engine option in the my.cnf configuration file. You may also want to change the default storage engine just for the current session. You can do this by setting the st, the default storage engine is used. Normally, this is MyISAM

If you omit the ENGINE option, the default storage engine is used. Normally, this is MyISAM, but you can change it by