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
