Fabio Cepeda

Posts Tagged ‘mysql foreign keys errno:150

Yesterday, I spent a few good hours finding why I was not able to create a table because of the infamous errno:150
What happended:

Set foreign key checks to 0
Dump some tables
Set foreing key checks to 1
Try to insert updated tables back in the DB and got the infamous error.

With relational DBs got to be careful with [...]