Hm, ok. Then one more followup question, if dropping the FKs is
necessary, is there any way to figure out how long such an operation
will take? SHOW PROCESSLIST usually just has "copying to tmp table"
or some such, does SHOW INNODB STATUS or any other commands give
insight into how long it will t
Hi Wayne,
On Feb 19, 2008 4:52 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> I'm trying to change the definition of a field and getting 1025 errors
> when I try. Here's a simplified reproducible test case, on MySQL 5.
>
> CREATE TABLE `Users` (
> `UserId` int(11) NOT NULL,
> PRIMARY KEY (`UserId`
I'm trying to change the definition of a field and getting 1025 errors
when I try. Here's a simplified reproducible test case, on MySQL 5.
CREATE TABLE `Users` (
`UserId` int(11) NOT NULL,
PRIMARY KEY (`UserId`)
) ENGINE=InnoDB;
CREATE TABLE `Actions` (
`ActionId` int(11) NOT NULL auto_incre
