Database server does not support the InnoDB storage engine in Magento

• zendnwar
• May 30, 2015
• Magento
• 0 Comments

It is very simple solution. Please follow the below step:

Go To the file app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php

Replace :

public function supportEngine()
{
$variables  = $this->_getConnection()
->fetchPairs(‘SHOW VARIABLES’);
return (!isset($variables[‘have_innodb’]) || $variables[‘have_innodb’] != ‘YES’) ? false : true;
}

With :

public function supportEngine()
{
$variables  = $this->_getConnection()
->fetchPairs(‘SHOW ENGINES’);
return (isset($variables[‘InnoDB’]) && $variables[‘InnoDB’] != ‘NO’);
}