#1062 - Duplicate entry error

I exported my database, changed some URL address references and when I import, I get a #1062 - Duplicate entry error. I tried exporting again leaving out the offending table but still get the same error.

I get the same error if I import the same file I have just exported with no changes.

Has anyone any suggestions?

If the database already has the same entries that you're importing, it won't work.

Thanks for your help

Duplicated installation. Created new database, imported altered database  - all good