I would first see if an upgrade to a later version of InnoDB tables is
possible.
What is being written to the error log?
The ALTER TABLE statement subtly creates a new table, with new contraint
names that the child table is unaware of, and drops the original table. Have
you tried rebuilding the
'; '[EMAIL PROTECTED] '
Subject: RE: Alter table primary key and foreign keys
I would first see if an upgrade to a later version of InnoDB tables is
possible. What is being written to the error log? The ALTER TABLE
statement subtly creates a new table, with new contraint names that the
child table
Can you mysqldump the table then rebuild the table from the dump file?
-Original Message-
From: Rich Schramm
To: 'Victor Pendleton'; [EMAIL PROTECTED]
Sent: 5/18/04 2:04 PM
Subject: RE: Alter table primary key and foreign keys
The error log shows nothing when the binary dies. I can't
[EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, May 18, 2004 11:05 PM
Subject: RE: Alter table primary key and foreign keys
Can you mysqldump the table then rebuild the table from the dump file?
-Original Message-
From: Rich Schramm
To: 'Victor Pendleton'; [EMAIL