MySQL Constraints: Import

Info.Tech, Linux System Administration, SQL: Structured Query Language, Web Development Add comments

I stumbled down again of database constraints when importing SQL dump file.

ERROR 1217 (23000) at line 128: Cannot delete or update a parent row: a foreign key constraint fails

The solution is add the following line in the beginning of the SQL dump file:


That should work.

Comments are closed.

WP Theme & Icons by N.Design Studio
Entries RSS Comments RSS Log in