Drupal Answers is a question and answer site for Drupal developers and administrators. It only takes a minute to sign up.
Sign up to join this community
When importing a dump from a production site with mysql in a xampp environment I got this error:
ERROR 1062 (23000): Duplicate entry '/-de' for key 'PRIMARY'
These lines are affected:
ALTER TABLE `redirect_404`
ADD PRIMARY KEY (`path`,`langcode`);
Strangely when importing the sql file into another database on the production server, it doesn't show any error.
There are many many posts about this error on the internet, but only in one I found the solution: https://dba.stackexchange.com/questions/46803/1062-duplicate-entry-but-there-are-no-duplicates/202891#202891
Apparently there was a value that should be entered in the path column which is longer than the defined 191 bytes, so it was truncated to that length, which caused duplicate values. So the solution is to clear all 404 log entries on /admin/config/search/redirect/settings and export the database again.
