MySQL InnoDB Tables [Archive]

PaulK

05-17-2005, 10:15 PM

On my two interworx servers I've noticed that I can't seem to create InnoDB tables with the version of mysql installed (4.0.21). Is it disabled for a reason or is this a bug? I have a client who would like to use them.

IWorx-Chris

05-17-2005, 10:40 PM

It's simply not on by default Paul. Edit the /etc/my.cnf and comment out the skip-innodb line and restart MySQL. That should get you going.

Chris

PaulK

05-17-2005, 10:46 PM

It's simply not on by default Paul. Edit the /etc/my.cnf and comment out the skip-innodb line and restart MySQL. That should get you going.

Chris

Ha, wow every time I ask a question here I get such a simple answer. For some reason it didn't even occur to me to look there. I see that i have 8 lines saying skip-innodb though :) I commented out one and deleted the other 7 and everything is working fine.