Archive » March 2016

#1452 – Cannot add or update a child row: a foreign key constraint fails…

MySql

Are you trying to import a MySql dump file and getting the following error: “#1452 – Cannot add or update a child row: a foreign key constraint fails”? Its because of the foreign key validation checks.

You can run the following statement to get detailed error information:

SHOW ENGINE INNODB STATUS;

Continue reading »

Back to top