Many Thanks :) Mike
> -----Original Message----- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED] > Sent: 30 April 2004 11:56 > To: Michael McTernan; Tom O'Neil > Cc: [EMAIL PROTECTED] > Subject: Re: Error dropping databases [in InnoDb] > > > Michael, > > Marko has fixed this to 4.0.19. > > Best regards, > > Heikki Tuuri > Innobase Oy > Foreign keys, transactions, and row level locking for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs > up MyISAM > tables > http://www.innodb.com/order.php > > Order MySQL technical support from https://order.mysql.com/ > > ----- Original Message ----- > From: "Michael McTernan" <[EMAIL PROTECTED]> > To: "Tom O'Neil" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, April 29, 2004 12:40 PM > Subject: RE: Error dropping databases [in InnoDb] > > > > Hi, > > > > I have found this too. I think it is as a result of a change introduced > in > > 4.0.18. From http://www.innodb.com/ibman.php#InnoDB.history : > > > > MySQL/InnoDB-4.0.18, February 13, 2004 > > - Do not allow dropping a table referenced by a FOREIGN KEY constraint, > > unless the user does SET FOREIGN_KEY_CHECKS=0. The error message here is > > somewhat misleading 'Cannot delete or update a parent row...', > and must be > > changed in a future version 4.1.x. > > > > It's a good change, but I'm guessing that InnoDb is handling a drop > database > > first as if all tables are being dropped in some arbirtary > order and hence > > not respecting foreign keys. > > > > One solution is to disable foreign key checks before the drop, and then > > re-enable them afterwards, or alternatively explicitly drop all > tables in > > the correct order before dropping the database. > > > > I wonder if there are any plans to fix this in future versions > on InnoDb? > > > > Thanks, > > > > Mike > > > > > -----Original Message----- > > > From: Tom O'Neil [mailto:[EMAIL PROTECTED] > > > Sent: 25 March 2004 22:07 > > > To: [EMAIL PROTECTED] > > > Subject: Error dropping databases > > > > > > > > > I am trying to drop several InnoDB and am unable to do > > > so. I login to the command line client and enter "drop > > > database [db_name];" and then get this error: > > > > > > ERROR 1217: Cannot delete or update a parent row: a > > > foreign key constraint fails > > > > > > Why am I unable to drop these databases? > > > > > > Tom > > > > > > ===== > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
