Everytime I try to import a backup of my CiviCRM sql database, I always get an error: #1062 - Duplicate entry '' for key 'UI_external_identifier' in phpmyadmin (4.7.0, PHP version: 7.1.4, mysql 5).
I noticed that this has to do with the UI_external_identifier in civicrm_contact, it's reading any records with a blank has having a duplicate entry. What would be the best way to handle this?
The options I am thinking of are:
- Option 1: Is there a way to change myphpadmin settings to NOT read blanks as duplicate entries? My other server does not have this problem when the external ID is NULL.
- Option 2: Set every ui_external_identifier to equal id value. This will ensure there is a value for every record, but I guess this would mean that I would have to use SQL to do it manually?