Enabling InnoDB databases
Following are the steps in order to enable InnoDB database.
1 ) Login to the server as root
2 ) Open the file /etc/my.cnf file.
3 ) Locate the line which says skip-innodb.
4 ) Comment the line. The entries should look somewhat similar as follows:
5) Now restart the mysql service on the server.
6) Now to check if the InnoDB support is enabled or not use the following command.
root@server [~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4923898
Server version: 5.0.91-community MySQL Community Edition (GPL)
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> show engines;
| Engine | Support | Comment |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |
| BerkeleyDB | NO | Supports transactions and page-level locking |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE | YES | Example storage engine |
| ARCHIVE | YES | Archive storage engine |
| CSV | YES | CSV storage engine |
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables |
| FEDERATED | YES | Federated MySQL storage engine |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |
7 ) The InnoDB support is now enabled on the server.