When we export our db and try restoring to another server we get the foreign key issue below so cant progress. Is it safe to Disable foreign key checks when importing into the new server?
(we tried to fix the indexes through the api even)
ALTER TABLE `civicrm_activity` ADD CONSTRAINT `FK_civicrm_activity_campaign_id` FOREIGN KEY (`campaign_id`) REFERENCES `civicrm_campaign` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_civicrm_activity_original_id` FOREIGN KEY (`original_id`) REFERENCES `civicrm_activity` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_civicrm_activity_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `civicrm_activity` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_civicrm_activity_phone_id` FOREIGN KEY (`phone_id`) REFERENCES `civicrm_phone` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `FK_civicrm_activity_relationship_id` FOREIGN KEY (`relationship_id`) REFERENCES `civicrm_relationship` (`id`) ON DELETE SET NULL
MySQL said: Documentation
1452 - Cannot add or update a child row: a foreign key constraint fails (
FK_civicrm_activity_campaign_idFOREIGN KEY (
id) ON DELETE SET NULL)