Posts tagged with ‘import mysql innodb’

How to import mysql innodb with foreign key constraint error?

advertisement

mysql, mysql dbTried to import a mysql innodb from a sql dump file, but it keep show me there is an foreign key constraint error. Due to innodb has foreign key check validation, it does not allow me to continue n show me foreign key constraint error. Ya! I know my data having some foreign key constraint problem, but what i need to do now is to import my sql dump file!

Here’s the error message “#1452 – Cannot add or update a child row: a foreign key constraint fails…”

After going thru the mysql documentation, finally i found the solution! This solution not only allow me to import my innodb, but also improve the import speed tremendously!

To import mysql innodb with foreign key constraint error, follow the steps below:-

Continue reading How to import mysql innodb with foreign key constraint error? »