RE: Error dropping databases [in InnoDb]

2004-04-30 Thread Michael McTernan
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, > > Ma

Re: Error dropping databases [in InnoDb]

2004-04-30 Thread Heikki Tuuri
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 da

RE: Error dropping databases [in InnoDb]

2004-04-29 Thread Michael McTernan
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