Re: Deleting Foreign Key

keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php . From: Mungbeans Date: January 2 2007 12:56am Subject: Deleting Foreign Key Get Plain Text I have a foreign key in a table which I need to drop. I have

Re: Deleting Foreign Key

Mungbeans wrote: ALTER TABLE `mytable` DROP FOREIGN KEY `keyname` #1025 - Error on rename of '.\database\mytable' to '.\database\#sql2-6ec-11' (errno: 152) ALTER TABLE `mytable` DROP INDEX `keyname` #1025 - Error on rename of '.\database\#sql-6ec_13' to '.\database\mytable' (errno: 150 Oh

Re: Deleting Foreign Key

until after my own caffeine boost also helped considerably! Cheers! -- View this message in context: http://www.nabble.com/Deleting-Foreign-Key-tf2905915.html#a8171880 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http

Deleting Foreign Key

and replace it with a different one and this is the only thing stopping me. -- View this message in context: http://www.nabble.com/Deleting-Foreign-Key-tf2905915.html#a8118367 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http