InnoDB storage engine

6 posts / 0 new
Topic locked
Last post
#1 Wed, 01/13/2010 - 10:10
kdr2000

InnoDB storage engine

Hello Is InnoDB storage engine installed on my Server with Virtualmin Package?? If NO, Can i install it? or it may be Confilect with other Virtualmin Modules. It's required to host Magento e-Commerce. Let me know, if it's there or not?? if it's there ,how can i enable it Thank you

Wed, 01/13/2010 - 11:19
andreychek

MySQL storage engines are installed as part of MySQL and it's related packages.

Whether or not it works on your server would completely depends on your distro, and how they packaged MySQL.

Typically, though, InnoDB support works out of the box.

You can get more info here:

http://dev.mysql.com/doc/refman/5.1/en/innodb.html

Of note, the above link explains that you can see what storage engines are available to you by logging into MySQL, and typing "show engines".

-Eric

Thu, 01/14/2010 - 23:11 (Reply to #2)
jackmatt2

You need to modify the my.cnf file to enable innodb. Comment out skip-innodb

Mon, 01/24/2011 - 08:59 (Reply to #3)
kdr2000

what is the path to my.cnf file i need to Comment out skip-innodb

khaled darwish

Mon, 01/24/2011 - 10:25
andreychek

Howdy,

The path to my.cnf depends on your distro... it's usually either in /etc, or /etc/mysql.

-Eric

Mon, 01/24/2011 - 11:01 (Reply to #5)
kdr2000

I could not find /etc/mysql but i found /etc/my.cnf which is speed dial file, what is the path to mysql????

khaled darwish

Topic locked