Magento Installation Requires InnoDB Storage Engine

Asked By 0 points N/A Posted on -
qa-featured

Dear Expert,

I’m in the middle of installing Magento on my computer. But the installation process was stopped by the error message when it tried to create the database in MySQL. The error message as follow: Database server does not support the InnoDB storage engine. Previously I’ve installed XAMPP version 1.7.4 contains Apache 2.2.17, PHP 5.3.5 and MySQL 5.5.8.

So, what I need to do so I can continue Magento installation process? What database server do I need to install Magento? I appreciate any help or solution from anyone here. Thanks.

Database server does not support the InnoDB storage engine.

SHARE
Best Answer by maryredington
Best Answer
Best Answer
Answered By 0 points N/A #120118

Magento Installation Requires InnoDB Storage Engine

qa-featured

Hi there! 

Your web host must support InnoDB, otherwise, this is not possible. So, first make sure that your web host provider does support innoDB. So, try to call them or by any means of support, make sure that they will be supporting InnoDB.

If that is not the case and you are running your own local host, then configure your mysql server.

Go to Xampp. Then Mysql. Then Bin.

Now find the file my.conf and edit that it supports InnoDB.

Take out the comments on all the InooDb starting commands. After all this , restart and you will be fine.

Cheers.

Answered By 10 points N/A #120119

Magento Installation Requires InnoDB Storage Engine

qa-featured

Hi,

Here is what you should do, but be careful while doing so. Go to this file app/code/core/Mage/installer/Db.php and find the line that says " //check innoDB support".

Comment out– that is put a "//" in front of–next three lines. Now it should work normally.

If it does not indicate that means that your server does not support InnoDB.

You should change your server to a more popular and reliable server like Hostgater

or ​Join Go Daddy Affiliate Program etc.

Regards,

Peter franklin

Related Questions