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.
Duplicate records in some database on the source server.
Unpack the backup archive hspc-mn-backup_2000.01.01.tar.bz2
Check mysql dump file:
vi +18637 ./tmp/db_dump.sql(+18637, because the line is specified in the error)
Check the request for duplicate records. Then go up in the file and note the database those records belong to.
Make a dump of that database on the source server.
Remove duplicate records from the appropriate database on the source server.
- Repeat migration attempt.