Hi,
Today i lost 2 forums of my board, was totally deleted, now i trying to apply my backup but i get the following error:

MySQL said:

#1062 - Duplicate entry '3' for key 1

Of course that mean the entry 3 is already in the db, but the problem is not only these entry , the problem are thousand of entrys,

Exist any way to apply my sql file avoiding these stops? (because phpmyadmin stops every time it find a duplicate entry, i want directly jump the duplicate entrys or directly overwrite)

excuse my bad english, and thanks in advance for your replys.

I have encountered the same problem on numerous occassions. The only work around that i found, was to always backup all my tables before doing anything drastic. As well as setting a schedule of backups. Then if it comes down to it, dropping all of the tables and reinserting the backup from the day before does not impact my users as much as say a backup from a month ago.

thanks for reply, i found a good way to solve my problem, i check the MySQL documents and i found the IGNORE command.

I modified my sql file, then i change:


Whit total commander i modified the sql file and replace ALL the

INSERT INTO

for:

INSERT IGNORE INTO

The command ignore simply ignore the duplicated entrys and follow adding all the entrys

best regards
Javier