Magento Installation Requires InnoDB Storage Engine

Asked By Alison Amira 0 points N/A Posted on - 08/31/2011

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.

• Status: Open
• Question Views: 3171
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: XAMPP

Best Answer by maryredington

Go To Solution

Best Answer

Best Answer

Answered By maryredington 0 points N/A #120118

Magento Installation Requires InnoDB Storage Engine

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.

About maryredington

Questions
0

Answers
10

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 08/31/2011
• Question Category: XAMPP

Answered By Peter franklin 10 points N/A #120119

Magento Installation Requires InnoDB Storage Engine

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

About Peter franklin

Questions
0

Answers
102

Best Answers
35

• Vote Up 0 Vote Down

• Posted on - 12/06/2012
• Question Category: XAMPP