RE: mysqldump and foreign keys

[Chetan Lavti]

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