mysql - ERROR 1452 (23000) does not print the line number in the data file sourced -
i importing data dump , error below. there way line number in source file caused this?
mysql> source datadump.sql; error 1452 (23000): cannot add or update child row: foreign key constraint fails ...
to add, dont see error messages in logs.
thanks..
instead of using source
command mysql monitor, use mysql
command directly shell:
$ mysql < datadump.sql
Comments
Post a Comment