1

I am trying to move my database from my usbwebserver to my online server. But I get this error, can anyone help me with this?

#1062 - Duplicate entry '1' for key 'PRIMARY'
2
  • 1
    Empty the database on the online server.
    – fuxia
    Jan 21 '16 at 13:58
  • Please accept answer if it helps you Nov 22 '16 at 7:14
8

in the export process from your server's PhpMyAdmin select Custom options, then - be sure to tick under Object Creation Options the next option:

Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement

than try to re import the DB

hope it helped

1
  • 1
    @Ritchie please accept if answer is correct. thanks :) Nov 10 '16 at 18:44

Not the answer you're looking for? Browse other questions tagged or ask your own question.