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'
-
1Empty the database on the online server.– fuxia ♦Commented Jan 21, 2016 at 13:58
-
Please accept answer if it helps you– elicohenatorCommented Nov 22, 2016 at 7:14
Add a comment
|
1 Answer
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 :) Commented Nov 10, 2016 at 18:44