How to set up INNODB

[mhburney]

Hi,
I want MySQL to use INNODB tables.I created the tables using innodb as stated on mysql website but not having any luck. I am interested in maintaining referential integrity between primary and foreign keys..meaning..

"if i update the value in one table the other tables gets updated automatically too"..and if not wrong Mysql doesnt support this feature but innodb does.

so how i can basically setup MySQL to use INNODB on linux.

Cheers!.

 

[TonyGroves]

MySQL supports InnoDB tables by default. To create an InnoDB table, just put "TYPE=INNODB" at the end of the table creation statement, though you probably don't even have to do that.

 

[mhburney]

no iam using MySQL version: 3.23.58 which doesnt have INNODB enabled by default...infact dunno if it even exists or not..

 

[TonyGroves]

This manual page explains InnoDB on MySQL 3.23:

http://dev.mysql.com/doc/mysql/en/innodb-in-mysql-3-23.html

 

[mhburney]

unfortunately its not that straight fwd. and it still seems like i wont have referential integrity within keys..can anyone tell me what the my.cnf file should look like..for innodb?

cheers!.