MySQL Tips

By Robert John Stevens, CEO of WriteExpress Corporation

How to enable InnoDB for MySQL

To enable InnoDB on a Linux server to install Magento eCommerce:

From a Linux shell type mysql and then SHOW STORAGE ENGINES; to see if InnoDB is enabled. If yes, the Support column will say YES.

If InnoDB is not enabled then type:
vi /etc/my.cnf
and comment out the line skip-innodb by adding the # sign before it. It should look like this:

#skip-innodb

Now save the file by entering:

:wq

And restart your mysql service with the following commands
mysqladmin -u root -p shutdown
/etc/rc.d/init.d/./mysql start

It worked for my running RedHat Linx and 5.0.51a-community MySQL Community Edition