FIX for “Database server does not support the InnoDB storage engine” in Magento

Copy the file:
app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php

Past it here(notice the only difference is core and local directory, if you don’t have the directory, just create it):
app/code/local/Mage/Install/Model/Installer/Db/Mysql4.php

Open the file you just pasted, go to line around 60, Replace
[code language=”php”]
public function supportEngine()
{
$variables = $this->_getConnection()
->fetchPairs(‘SHOW VARIABLES’);
return (!isset($variables[‘have_innodb’]) || $variables[‘have_innodb’] != ‘YES’) ? false : true;
}
[/code]

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