Enabling InnoDB storage engine in MySQL



MySQL is capable to store data in a variety of formats. The default format is MyISAM which offers performance and it is used by most web services. InnoDB is transactional and it is used in heavy environments thanks to row-level locking.

Last days I tried to install a PHP application on server and I got the error "InnoDB storage engine is not supported".

To enable InnoDB – follow these steps:

Alter my.cnf and comment the line

#skip-innodb

 

Restart mysql

/etc/init.d/mysql restart

 

You can check if InnoDB storage engine is enabled by simply querying the MySQL:

mysql> show variables like 'have_inno%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb   | YES   |
+---------------+-------+
1 row in set (0.00 sec)