Magento Troubleshooter. How to deal with “Database server does not support InnoDB storage engine” error message

This tutorial will show you how to detail with ‘Database server does not support the InnoDB storage engine’ error message while installing Magento engine.

Such issue is caused by a wrong MySQL version on the server. Usually, the issue occurs while installing Magento 1.7 on the server with MySQL 5.6.

With the solution below, this will no longer be a problem.

1. Access your server using any ftp software or FileManager provided by your Host.

2. Open ‘app/code/core/Mage/Install/Model/Installer/Db/Mysql4.php’ file with any PHP/Text editor:

   

3. Replace the following part of the code:

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

   with the code below:

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

4. Save the file and refresh your website.

5. You can now start new Magento engine installation:

   

An alternative solution for the issue would be contacting your hosting provider and asking to downgrade MySQL version on the server (if such option is available for your Hosting Plan).

Feel free to check the detailed video tutorial below: