If this tutorial is not what you were looking for, you still have any questions, suggestions or concerns - feel free to let us know. Please help us to serve you better!

Your Name

Your Email

Your Message (required)

captcha

Featured templates

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.

Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_1

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:

    Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_2
  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:

    Magento_Troubleshooter_How_to_deal_with_Database_server_does_not_support_InnoDB_storage_engine_message_error_message_3

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:

Magento Troubleshooter. How to deal with “Database server does not support InnoDB storage engine message” error message
 
Live Chat
We help you to choose the right product.
Start chat