Database server does not support the InnoDB storage engine in Magento
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’);
}