ERROR 1062 (23000) at line 3907: Duplicate entry '1985' for key 'PRIMARY'

Question

After trying to import my database.sql, I received this error.

I've tried to read here but I really don't understand them. Is there a solution that I can use to import my database properly?

Thanks,

You have 2 entries with primary key 1985. maybe you want to drop all other records before importing? — juergen d, Mar 28 '15 at 19:18
I already dropped the database, but still receiving the same error. I'll try again. — user3416962, Mar 28 '15 at 19:22

score 0 · Answer 1 · edited May 23 '17 at 12:09

0

You have the same Primary Key in your import file. Go to that line and remove that line or the second possibility is that you set the flag to ignore the IDs but then you have inconsistent data and a dublicate primary key.

How to skip row when importing bad MySQL dump

edited May 23 '17 at 12:09

Community

1
1

answered Mar 28 '15 at 19:35

René Höhle

26,716
22
73
82

score 0 · Answer 2 · answered Sep 28 '16 at 10:37

0

It is a bug. Just change INSERT INTO to REPLACE INTO in self-contained file.

answered Sep 28 '16 at 10:37

Oleg Mikhailov

252
1
8

score 0 · Answer 3 · answered Feb 22 '17 at 05:23

0

Because the Primary-key,we can't insert duplicate data,so before import database sql files,we must clear the database or tables;

answered Feb 22 '17 at 05:23

Michael Lee

1

ERROR 1062 (23000) at line 3907: Duplicate entry '1985' for key 'PRIMARY'

3 Answers3