[mythtv-users] mythconverg_restore.pl: Duplicate entry for key 'PRIMARY'

[Jon Whitear]

Hi folks,

I'm trying to migrate my database to a new back end, following the wiki.

When I try to restore a backup on the new machine, I get this:-

jon at newmedia:~$ sudo ./mythconverg_restore.pl  --drop-database --create-database --directory /home/jon --filename mythconverg-1317-20150301163436.sql.gz
[sudo] password for jon:
ERROR 1062 (23000) at line 2708: Duplicate entry '2684354578-0000-00-00 00:00:00--51-589824' for key 'PRIMARY'

ERROR: Cannot write to mysql, stopped at ./mythconverg_restore.pl line 1720, <BACKUP> line 2709.
jon at newmedia:~$

This database is 10 years old, so I wouldn't be surprised if it has some cruft lying around. I have no idea how to fix this. I would appreciate any help.

Cheers,

Jon