enable_innodb

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 instal 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)