Error Importing Mysql Database Dump

[lucatoni]

Please can someone help me

I tried restoring my database backup as usual. Unfortunately, I started noticing this error message. I don’t really know what to do.

 

“The query and the error message has been logged at:

C:UsersLuca-toniAppDataRoamingSQLyogsqlyog.err.

Please click on “Open Error File…” to open the error file.”

 

I have viewed the log error too. This is what i see “Error occured at:2015-02-06 13:04:37

Line no.:326

Error Code: 1452 – Cannot add or update a child row: a foreign key constraint fails (`crhdss`.`adultvpm`, CONSTRAINT `FKD41094F9301AAA96` FOREIGN KEY (`visit_uuid`) REFERENCES `visit` (`uuid`))”

 

Please your help

[peterlaursen]

The dump does not have the statement “SET FOREIGN_KEY_CHECKS = 0;” on top. It should have if you are using Foreign Keys in the database. There is no way to ensure that ‘parent’ tables are written to the dump file before ‘child’ tables. 

 

Refer MySQL documentation http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_foreign_key_checks ” Disabling foreign key checking can be useful for reloading such tables in an order different from that required by their parent/child relationships”. 

 

SQLyog does write “SET FOREIGN_KEY_CHECKS = 0;” on top as default? Did you use SQLyog to create the dump? If so, did you uncheck this? 

[lucatoni]

wow!

Thank you so so much.

It worked. I am using sqlyog and the “SET FOREIGN_KEY_CHECKS = 0;” was not checked.

Thanks

[Author]

Posts