Why mysql "ENGINE=InnoDB" doesn't work with joomla 3 installation

Question

I got the solution for joomla 3 installation problem(installation stucks in creating databases) in stackoverflow.

The solution that to replace "ENGINE=innoDB" with "ENGINE=MyIsam" in

joomla-folder\installation\sql\mysql\joomla.sql, it works well.

Anyone know the reason why innoDB is not working with joomla 3 installation.

And do I need to restore the engine from "MyIsam" to "innoDB" again(after installed successfully)?

Answer 1

It is because MyIsam is supported and compatible more with Joomla. You can check here

And do I need to change the engine to "innoDB" again(after installed successfully)

If you have changed it while installing it then there is no need to change it again.