0

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'
  • 1
    Empty the database on the online server. – fuxia Jan 21 '16 at 13:58
  • Please accept answer if it helps you – elicohenator Nov 22 '16 at 7:14
7

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
    @Ritchie please accept if answer is correct. thanks :) – elicohenator Nov 10 '16 at 18:44

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