tags:

views:

11

answers:

1
Q: 

Innodb foreign key constraints

I am trying ti change the type in two tables of an innodb. The problem is that the values are a key and a foreign key. When I try to make the change I get the error #1025 error on rename

Do I need to drop the foreign keys and then make the changes and then reapply the foreign key?

A: 

Yeah, you have to drop the foreign key. Try SHOW INNODB STATUS to see if there's a more elaborated explanation of what's going on.

racetrack  2010-09-07 22:56:39

related questions

INNODB Cascade Syntax / Logic Problem
How to predict MySQL tipping points?
mySQL database efficienty question
Should I COUNT(*) or not?
Changing tables from MyISAM to InnoDB make the system slow
MySQL AUTO_INCREMENT does not ROLLBACK
MySQL transaction support with mixed tables
Foreign key not working in MySQL: Why can I INSERT a value that's not in the foreign column?
Why does MySQL add a comment to InnoDB tables?
MySQL (InnoDB): need to delete column, and accompanying foreign key constraint and index
Is there a REAL performance difference between INT and VARCHAR primary keys?
Setting innodb_log_file_size crashes MySQL
Mysql InnoDB "error 32" on Windows
MySql: MyISAM vs. Inno DB!
MySQL MyISAM & innoDB Memory Usage
How do I repair an InnoDB table?
Are there any pitfalls / things you need to know when changing from MyISAM to InnoDB
mysql "drop database" takes time -- why?
How can I be sure the whole MySQL DB is loaded in memory?
What's the quickest way to dump & load a MySQL InnoDB database using mysqldump?
MySQL InnoDB database restore
How to enable inno-db support on MySql 5 installed above MySql 4?
How can MyISAM tables be used more safely?
In what order are ON DELETE CASCADE constraints processed?
MyISAM versus InnoDB