Home / mysql workbench Cannot add or update a child row: a foreign key constraint fails import

mysql workbench Cannot add or update a child row: a foreign key constraint fails import

solution:
mysql> SET foreign_key_checks = 0;
mysql> SOURCE your_db_dump_file;
mysql> SET foreign_key_checks = 1;



    		 RSS of this page