Restoring a backup that has UNIQUE index violations in it

[Tim Nope]

Hello,

I need to restore a MySQL database from a SQL-File. (The file, db_backup.sql, was created by PhpMyAdmin). I use the following command to restore the file:

mysql -u root -pMySecretPwd dbname < db_backup.sql


After some time, I get the following error message:

ERROR 1062 (23000) at line 604815: Duplicate entry 'Aircon' for key
'busfeatures_name_UNIQUE'

So I guess some data in the backup violates the unique constraint (most likely because it was inserted before the constraint was in place).

What is the best practice to restore the backup?

Thanks in advance,

Tim