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

    WHD MySQL Database Migration

    baldock88

      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.

       

      Thanks!