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.
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.
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.