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)?

Did you check which engines your MySQL installation supports? — Mjh, Sep 25 '15 at 10:46
@Mjh You are right, mysql version might be the issue. if mysql version is 5.5 or latest , then there will be no issue it seems. — Muthu kumar, Sep 25 '15 at 13:20

score 1 · Answer 1 · answered Sep 25 '15 at 10:47

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.

1 Answers1