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