you all were right, the database is not supporting the InnoDb tables;
I configure it with "--with --innodb" option & add innodb_data_file_path to the my.cnf. Now it's working!!
Thank you so much
Vinita
sql
Dyego Souza do Carmo wrote:
vvM> HI
vvM> still not working :-(
vvM> I didn't do the installation , Do we need to set any option vvM> specifically during the installation for foreign key to work??
The InnoDB is loaded ?
please run
show variables like '%innodb%';
and put here.
tnks.
sql,query
-------------------------------------------------------------------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento -------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php