Re: Bogus ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails

[JD Brennan]

I found the problem. First I added:

set-variable = lower_case_table_names=0

to /etc/my.cnf and restarted mysqld.

I had moved from Windows to Linux, and
the mysqldump on Windows downcased all
the table names in the foreign key
definitions. So I did some post-processing
on the mysqldump file to upcase the table names,
the recreated the database from the dump file
and everything is working now.

JD



Edited 1 time(s). Last edit at 02/29/2008 06:13PM by JD Brennan.