2 Replies Latest reply on Nov 30, 2015 9:39 AM by baldock88

    WHD MySQL Database Migration


      Hey everyone,


      Running into a problem trying to migrate our database from one server to another with the same version of MySQL installed on both.


      When I do a SQL dump of the database I get no errors, and when importing into the new server I don't get any errors either.


      When I go to update some tech details or make any changes to configurations I run into the following error:


      Error: com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: : Next exception:SQL State:23000 -- error code: 1452 -- msg: Cannot add or update a child row: a foreign key constraint fails (`whd`.`LOCATION_GROUP_CLIENT`, CONSTRAINT `LOCATION_GROUP_CLIENT_client_FK` FOREIGN KEY (`CLIENT_ID`) REFERENCES `tech` (`CLIENT_ID`))


      Has anyone seen anything like this? I've tried shutting off and blocking the foreign key checks and contraints, but it doesn't seem to help.