thank u very much... but I am planning for one approach is it right .. as by mysqldump we can take back up of Table structure and Insert values separately.. As my database will remain constant through out for the application I can insert the foreign key lines in the dumped file once and as the insert values are in the separate file, when ever I will do backup first I will use the Table structure file which will be constant(will not be backup every time) and then the backup data file.
This way I am able to make get the Foreign key even my using the mysqldump.. What do u say ..?? anybody who can suggest me any idea.. I have also tried for the "Alter table Add " but it is not working. Thanks and regards. Chetan Lavti -----Original Message----- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 24, 2002 4:33 PM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: mysqldump : help needed very urgent Hi! >>>>> "Chetan" == Chetan Lavti <[EMAIL PROTECTED]> writes: Chetan> Hi, Chetan> I am using Mysql version 3.23.47-Max client and server and using Innodb Chetan> table type. Chetan> I am doing my database backup using the mysqldump utility. Chetan> Once I have done with database backup, I am deleting all my database and Chetan> again recovering(creating) the database using the dumped file. Chetan> Now, the question is after recovery of the database, I am not getting Chetan> the foreign key relationship between the tables. Chetan> Why this happens...? is it the problem with mysqldump...?? and if it Chetan> really the case then how can i re-create my whole database and keep all Chetan> my database retaining the foreign keys. Chetan> If anyone can suggest me alternative method for doing the same then it Chetan> will be very usful for me. Chetan> Waiting for response..... The problem here is that in MySQL 3.23 FOREIGN KEY definitions is not part of the mysqldump output. This will be fixed in MySQL 3.23.50 and 4.0.2, both which will be available shortly. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- 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
