Unable to restore backup data, unique index is duplicated

You have a corrupt index. You’ll need to fix it on the existing site and then create a new backup before you can restore. See Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes). That was for a different table, so you’ll need to adjust those instructions significantly. If you don’t know much about databases, it’ll be hard