Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to set up INNODB

Status
Not open for further replies.

mhburney

Programmer
Jul 26, 2005
23
PK
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!.
 
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.
 
no iam using MySQL version: 3.23.58 which doesnt have INNODB enabled by default...infact dunno if it even exists or not..:(
 
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!.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top