Author Topic: Foreign key constraint error on phpmyadmin import (Read 4318 times)

palmquist · March 10, 2010, 07:54:10 am

I have re-installed Drupal and CiviCRM and am trying to restore my data, and phpmyadmin keeps giving me a foreign key constraint error. I now see that I should have disabled foreign key constraints upon exporting, but is there anything I can do now to get my data back?

Piotr Szotkowski · March 11, 2010, 01:00:59 am

Quote from: palmquist on March 10, 2010, 07:54:10 am

I have re-installed Drupal and CiviCRM and am trying to restore my data, and phpmyadmin keeps giving me a foreign key constraint error. I now see that I should have disabled foreign key constraints upon exporting, but is there anything I can do now to get my data back?

Check this reply – you can simply open the dump with a text editor and add

Code: [Select]

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

at the beginning and

Code: [Select]

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

at the end.

CiviCRM Community Forums (archive)

News:

Author Topic: Foreign key constraint error on phpmyadmin import (Read 4318 times)

palmquist

Foreign key constraint error on phpmyadmin import

Piotr Szotkowski

Re: Foreign key constraint error on phpmyadmin import