Article ID: 122935, created on Sep 17, 2014, last review on Sep 17, 2014

  • Applies to:
  • Odin Business Automation Standard 4.5

Symptoms

Migration fails with following error:

[INFO ] [Backup] Restoring management node from backup...
ERROR 1062 (23000) at line 18637: Duplicate entry 'domain.com-aspc-aspcomplete' for key 'PRIMARY'
[ DIE ] [Backup] Unable to restore dump.

Cause

Duplicate records in some database on the source server.

Resolution

  1. Unpack the backup archive hspc-mn-backup_2000.01.01.tar.bz2

  2. Check mysql dump file: vi +18637 ./tmp/db_dump.sql (+18637, because the line is specified in the error)

  3. Check the request for duplicate records. Then go up in the file and note the database those records belong to.

  4. Make a dump of that database on the source server.

  5. Remove duplicate records from the appropriate database on the source server.

  6. Repeat migration attempt.

Search Words

Unable to restore dump

ERROR 1062 (23000) at line 18637: Duplicate entry

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 624ca542e40215e6f1d39170d8e7ec75 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF