hi, I think u r right.. because after recovering from the dumped database, when insert a value in the foreign key column which is not present in the primary key, it accepts the row inserted. which is not true when I do the same think from the mysql command prompt,( before dumping) Anybody who has experience with the same problem and is it really the true.. if it is true then what's the use of mysqldump ..( which makes someone's database scattered.) Help me also !! it is urgent .. Thanks and regards, Chetan Lavti -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 9:35 PM To: Chetan Lavti Subject: Re: mysqldump and foreign keys (possible Bug ??) No, not working, When I run the command SHOW TABLE STATUS FROM yourdatabasename LIKE 'T'; shown in the manual (7.5.4.2 Foreign Key Constraints) I will see the foreign key (in the comments collumn). But if I dump and then reload the dump into mySQL the foreign key is gone. Experts, is this a BUG ???? Adib. Chetan Lavti wrote: > hi, > I am also using the Innodb table type for my database. when I am using > the mysqldump for dumping the tables it really doesn't shows the > foreign key in the table structure. > but if after deleting my previous database I again create my database > using the same dumped file and executes the > > mysql>desc <tablename> > > (at mysql command prompt) it shows the foreign keys.. > > am i right..?? Actually, I also wanted to know !! I am telling u what i > have done and seen. Please, u also try for the same and see if it works > fine. > please, tell me also regarding this... > > Thanks and regards, > Chetan Lavti > > > --------------------------------------------------------------------- > 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 > -- WIGE DATA GmbH Wiesenring 11, D-04159 Leipzig, Germany Adib Taraben Electronic Engineer PHONE +49 (0)341 - 46 21 100 FAX +49 (0)341 - 46 21 400 E-MAIL [EMAIL PROTECTED] INTERNET www.wige-data.de A company of WIGE MEDIA AG --------------------------------------------------------------------- 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