Installing magento - Database server does not support InnoDB storage engine

Installing magento - Database server does not support InnoDB storage engine

September 30, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Installing magento - Database server does not support InnoDB storage engine

Installing Magento: Resolving “Database Server Does Not Support InnoDB Storage Engine” Error

Are you facing issues while installing Magento on your local server? The error “Database server does not support InnoDB storage engine” can be quite frustrating, especially when you’re trying to set up a development environment. Let’s dive into this problem and find a practical solution.

Understanding the Problem: Why InnoDB Matters for Magento

Magento requires MySQL with the InnoDB storage engine to function correctly during its installation process. InnoDB provides ACID compliance (Atomicity, Consistency, Isolation, Durability) which is essential for handling transactions and maintaining data integrity in e-commerce platforms.

However, if your MySQL version is 5.6 or earlier, it might not support the InnoDB engine by default. This is where the error occurs during Magento’s database connection check.

Why Changing the my.ini File Might Not Work

You mentioned that you tried to enable the InnoDB engine by modifying the my.ini file:

innodb_data_home_dir = C:\mysql\data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = C:\mysql\data/
innodb_log_arch_dir = C:\mysql\data/
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

However, when you try to start the MySQL service, it fails. This could be due to incompatible configurations or insufficient memory allocation for InnoDB.

The Role of InnoDB in Magento Installation

When you run the SHOW ENGINES command, you should see a list of supported engines:

+--------------------+----------+----------------------------------------------------------------+
| Engine             | Support  | Comment                                                        |
+--------------------+----------+----------------------------------------------------------------+
| MyISAM             | DEFAULT  | Default engine for most tables                               |
| InnoDB             | NO       | Supports transactions, row-level locking, and foreign keys   |
+--------------------+----------+----------------------------------------------------------------+

The critical point here is that Magento expects the database server to support the InnoDB engine. If it’s marked as ‘NO’ in the Support column, you’ll encounter the error during the installation.

Downgrading MySQL or Upgrading Your Local Server

Since WampServer 2.4 ships with MySQL 5.6 by default, downgrading to an older version (like 5.1) isn’t recommended as it might expose security vulnerabilities and lack critical features.

The best approach is to upgrade your local server’s MySQL version to at least 5.7 or later. This can be achieved using the MySQL installer provided by WampServer, which allows you to choose the MySQL version during installation.

Ensuring a Clean Magento Installation

If upgrading the MySQL version doesn’t resolve the issue, let’s consider other potential problems:

  1. Permissions issues: Ensure that your MySQL server and data directories have proper read/write permissions for the user running the WampServer service.

  2. Magento files integrity: Double-check if you’ve downloaded the full Magento release package instead of the downloader version. The error about missing app/Mage.php might indicate an incomplete or corrupted download.

  3. Compatibility issues: Verify that your PHP version and other server configurations are compatible with the Magento version you’re trying to install.

Conclusion: Resolving the InnoDB Error in Magento Installation

In summary, resolving the “Database server does not support InnoDB storage engine” error in Magento installation requires:

  1. Upgrading MySQL: Ensure your local server’s MySQL version is 5.7 or later to support the InnoDB engine.

  2. Configuring InnoDB correctly: If you still need to enable InnoDB manually, consult the official MySQL documentation for proper configuration guidelines.

  3. Verifying your Magento files: Ensure you have a clean, complete Magento release package before proceeding with the installation.

Remember to always backup important data and test changes in a staging environment whenever possible.

For more detailed guides on setting up local development environments and working with Magento, consider exploring our Magento Development category at Laravel Company. We provide practical tips and best practices for developers like you.

Happy coding!

Database Errors

Our network