Error restoring DB backup

[oroedel]

My ex-provider (gangsters) canceled my account and I can´t access my forum anymore.
I have only a DB backup with structures, now at the new provider installed smf and created a new empty db.
Importing the backup fails with this, what can I do?



--
-- Dumping data in `smf_log_search_subjects`
--

INSERT INTO `smf_log_search_subjects`
   (`word`, `id_topic`)
VALUES (1, 141),
   (15, 326),
   ('1971-1973', 306),
   (2, 142),
   ('24hs', 361),
   ('4-way', 144),
   ('4er', 150),
   ('4er', 156),
   ('4er', 163),
   ('4x4', 146),
   ('6er', 153),
   ('a', 55),
   ('a', 98),
   ('a', 117),
   ('a', 139),
   ('a', 140),
   ('a', 193),
   ('a', 209),
   ('a', 251),
   ('a', 265),
   ('a', 322),
   ('açucar', 316),
   ('abeja', 10),
   ('abeja', 69),
   ('abejas', 19),
   ('abejas', 313),
   ('abelha', 98),
   ('abelha', 120),
   ('abelha', 124),
   ('abelha', 278),
   ('abelhas', 7),
   ('abelhas', 11),
   ('abelhas', 48),
   ('abelhas', 248),
   ('abelhas', 266),
   ('abelhas', 300),
   ('abelhas', 348),
   ('abelhas', 359),
   ('ablegerbildung', 244),
   ('about', 16),
   ('absorvente', 271),
   ('acaricida', 330),
   ('acaricidas', 226),
   ('acácia', 304),
   ('acid', 230),
   ('acid', 232),
   ('acid', 308),
   ('acido', 176),
   ('acido', 272),
   ('acids', 237),
   ('[...]

Mensagem do MySQL: Documentação
#1062 - Duplicate entry 'ácido-193' for key 'PRIMARY'

[Sir Osis of Liver]

Ask your host to import the backup to the new db.

[oroedel]

why I should do this? It isn´t an error in the database?

[Kindred]

I would guess that you are trying to import into the wrong collation.

If your original database was UTF8, your new one has to be as well.   and vice-versa

[oroedel]

ok, kindred, that could be...
where I choose this?

In server collation, there are MANY options, or I choose it when I create the db or at import?

Find out I can chooe this in the database, but which is the right value, utf8-bin!? or what else, looked in the back up file there I didn´t found "collation" or a utf value...

Thanks for your help

[oroedel]

i used the new smf installation to convert the database via admin panel in utf, then I looked at phpMyAdmin and now the tables are "utf8_general_ci", I guess I need convert the empty db in this format and import in this format!?

[oroedel]

converted the empty db in utf8_general_ci and imported as utf8, same error!
I missed something? Is the backup file in another format?

[oroedel]

What I did:
- loaded the backup in wordpad, deleted the whole "log_search_subjects" entry
- imported in an empty db (utf8_genral_ci)
- used repair_settings.php
- used repair db in smf admin

Ready, it works!