Philip, -----Original Message----- From: Philip Molter <[EMAIL PROTECTED]> To: Heikki Tuuri <[EMAIL PROTECTED]> Cc: Bob McLaughlin <[EMAIL PROTECTED]>; MySQL Mailing List <[EMAIL PROTECTED]> Date: Tuesday, March 12, 2002 4:21 PM Subject: Re: Foreign keys in mysqldump?
>On Tue, Mar 12, 2002 at 11:50:12AM +0200, Heikki Tuuri wrote: >: Bob, >: >: I have now improved foreign key support so that version 3.23.50 does >: >: 1. show the FOREIGN KEY definitions when you call SHOW CREATE TABLE; this >: should also show them in mysqldumps; >: 2. preserve FOREIGN KEY definitions in ALTER TABLE and CREATE INDEX; >: 3. allow backquotes around column and table names in foreign key >: definitions: backquotes are produced by SHOW CREATE TABLE; >: 4. allow adding a new foreign key constraint ot a table through >: ALTER TABLE ... ADD CONSTRAINT FOREIGN KEY (...) REFERENCES ... (...); >: remember though that you first have to create the appropriate indexes on the >: parent and child table so that InnoDB approves the constraint. > >Heikki, > >That is fantastic news! As far as everyday usage of InnoDB tables >goes, those are the number one issues we have to work around. >Thanks for taking the time to implement that. thank you! >Speaking of InnoDB development, what is the status on the InnoDB >backup utility? The beta testing of InnoDB Hot Backup (a non-free add-on tool) started on Monday. If you want to take part in the beta testing, look at http://www.innodb.com >* Philip Molter >* Texas.net Internet >* http://www.texas.net/ >* [EMAIL PROTECTED] --------------------------------------------------------------------- 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