(error) Cannot add or update a child row: a foreign key constraint fails

2021-02-21 MySql shark 1 min read

Solution 1: skip the foreign key check when importing database.

mysql -u root -p SET FOREIGN_KEY_CHECKS=0 jobyme88 < jobyme88-2021-2-21.sql
mysql -u root -p SET FOREIGN_KEY_CHECKS=1

You must be logged in to post a comment.

Leave a Reply