BiobankPanel investigation.name problem with some of the duplicate values in name field. general population is imported ok , but melanoma is a problem . || name || investigation_name || Category || Subcategory_name || Coordinators_Lastname || Size || Biodata_name || !GwaDataNum || !GwaComments || !GeneralComments || || general_population || LRGP || Core Biobanks || Population development || lal1 || 122 || .. || ... || ... || ... || || general_population || epic-nl || core biobanks || population development || la2 || 100 || .. || .. || . || .. || || melanoma || GenoMEL || Core Biobanks || Population, development, birth and growth || lala || 1200 || dna || 600 || blabla || bla blabla bla || || melanoma || POLYGENE || Core Biobanks || Aging || blabla || 800 || plasma || 197 || blabla || bla || compare -- diff bbmri_29_march.mysql ~/Desktop/bbmri_gcc_22march_backup.mysql : except from the capitalized constraint in every CONSTRAINT, there are differences that may produce this problem :  added constrain in Measurement entity :  <   KEY !`targettypeAllowedForRelation` (!`targettypeAllowedForRelation`), '''<   CONSTRAINT !`measurement_ibfk_3` FOREIGN KEY (!`targettypeAllowedForRelation`) REFERENCES !`molgenisentity` (!`id`),''' <   CONSTRAINT !`measurement_ibfk_1` FOREIGN KEY (!`id`) REFERENCES !`observablefeature` (!`id`) ON DELETE CASCADE, <   CONSTRAINT !`measurement_ibfk_2` FOREIGN KEY (!`unit`) REFERENCES !`ontologyterm` (!`id`) --- >   CONSTRAINT !`Measurement_ibfk_1` FOREIGN KEY (!`id`) REFERENCES !`ObservableFeature` (!`id`) ON DELETE CASCADE, >   CONSTRAINT !`Measurement_ibfk_2` FOREIGN KEY (!`unit`) REFERENCES !`OntologyTerm` (!`id`) ----------------------------removed constraint from entity 812,813c795,797<   UNIQUE KEY !`name` (!`name`),<   CONSTRAINT !`observationtarget_ibfk_1` FOREIGN KEY (!`id`) REFERENCES !`observationelement` (!`id`) ON DELETE CASCADE--->   UNIQUE KEY !`Investigation_name` (!`Investigation`,!`name`),>   CONSTRAINT !`ObservationTarget_ibfk_1` FOREIGN KEY (!`id`) REFERENCES !`ObservationElement` (!`id`) ON DELETE CASCADE,>   CONSTRAINT !`ObservationTarget_ibfk_2` FOREIGN KEY (!`Investigation`) REFERENCES !`Investigation` (!`id`)