Hi! FOREIGN KEY definitions are stored inside InnoDB data files. Thus, if you make a 'binary' backup, it will preserve foreign key definitions.
Starting from 3.23.50 and 4.0.2 mysqldump dumps also foreign key definitions. Previously it forgot them because it did not read them from inside InnoDB. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB -----Original Message----- From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Date: Monday, March 25, 2002 10:44 AM Subject: Re: mysqldump : help needed very urgent >Hi, > >as far as we are waiting for 3.23.50 this sounds as a stable version to >do a backup. :-) >But I wonder weather there is also a binary backup for this case? Lets >say copy all tables and store in a zip (for ISAM tables ok but >InnoDB???), or make a mysqlhotcopy. > >Adib. > >Chetan Lavti wrote: >> 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 >> > > >--------------------------------------------------------------------- >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 > --------------------------------------------------------------------- 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
