Prob with Foreign Keys using INNODB
I have a problem...
all these days we were working with MYISAM tables...
as there is no support for foreign key and references...we tried doing with INNODB type..
we just added a line in my.cnf [mysqld] section :
innodb_data_file_path=ibdata1:10M:autoextend:max:300M
but looks like mysql is not recognising the INNODB tables..
i mean still the foreign key constraint is not working as it shud...
is there anything else that we have to configure?
or anything else to be edited in my.cnf..
or the way to create INNODB tables is different...
Please help me in detail....
Thanx in advance.
Subject
Written By
Posted
Prob with Foreign Keys using INNODB
August 26, 2004 04:33AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.