, December 03, 2003 6:41 AM
Subject: Drop foreign key replication problem
Hi,
I am running a master and a slave. When I created a foreign key in
master, it looked like this:
CONSTRAINT `0_373` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture`
(`id`)
But on the slave it was like
`)
The problem is, when I deleted this foreign key on master using command:
ALTER TABLE input DROP FOREIGN KEY 0_373
The slave produced an error:
ERROR: 1025 Error on rename of './new_atpress/input' to
'./new_atpress/#sql2-3a54-2' (errno: 140)
031203 13:27:30 Slave: Error 'Error on rename
Hello,
how can i delete an foreign key between two tables? Is there a drop foreign
key - command available?
Thanks
Nico
--
+++ GMX - Mail, Messaging more http://www.gmx.net +++
Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!
--
MySQL General Mailing List
For list archives
# [EMAIL PROTECTED] / 2003-06-27 09:45:06 +0200:
how can i delete an foreign key between two tables? Is there a drop foreign
key - command available?
yes, read:
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
--
If you cc me or remove the list(s) completely I'll most likely
Hi Nico,
I understood that DROP FOREIGN KEY is not supported before Version 4.0.13.
( In such case you will have to drop the table and recreate it.)
Best regards
Nils Valentin
Tokyo/Japan
2003 6 27 16:45Nico Gr :
Hello,
how can i delete an foreign key between two tables? Is there a drop