MySQL Dump Issue

3rd party extensions (phpDivingLog, dive computer downloader,...)
Post Reply
ehelm
Posts: 29
Joined: Sun Jun 24, 2007 12:42
Location: Norway
Contact:

MySQL Dump Issue

Post by ehelm » Sun Jul 22, 2007 11:16

Hi All,
When I do an export MySql Dump the first time in a empty DB, everything goes fine. When I try to add dives to the existing DB i get problems. I am also adding only the last dive number but I get an error. It is saying: Error Number: 1062 Duplicate entry 1 for key 1

I am tying to upload a dive the is not in the MySql database on the web and putting this in the General page on the Mysql dump export. I am also chosing Only Data.

Please help!

Regards,

divinglog
Site Admin
Posts: 4987
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Post by divinglog » Sun Jul 22, 2007 14:22

OK, I'll check this tomorrow.

ehelm
Posts: 29
Joined: Sun Jun 24, 2007 12:42
Location: Norway
Contact:

Post by ehelm » Sun Jul 29, 2007 22:13

Any luck yet???? :-)

divinglog
Site Admin
Posts: 4987
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Post by divinglog » Sun Jul 29, 2007 22:29

I've checked it and it works. So there must be already a dive in this table with the same ID. The easiest way to solve this is to select "Structure and Data" and checked "Drop Table" when exporting. This will delete the whole MySQL table, create it new and import all dives.

The next time you should be able to export only the new dives, with option "Data only" and without checking "Drop table".

ehelm
Posts: 29
Joined: Sun Jun 24, 2007 12:42
Location: Norway
Contact:

Post by ehelm » Wed Aug 08, 2007 08:28

Thanks again..it works for me too now. I want to also say thanks for this great Support Forum. :D

Post Reply