I have a lot of data in a pointshop database which I converted to MySQL from pdata. Everytime I import the SQL file this happens:
[CODE]SQL query:
INSERT INTO `pointshop_data`
VALUES (
'993283467', '260', '[]'
);
MySQL said: Documentation
#1062 - Duplicate entry '993283467' for key 'PRIMARY' [/CODE]
The issue is, the primary key is defined as uniqueid, which is unique, and shouldn't have any duplicates. I have looked through the SQL dump and have found no duplicates of the many different ID's it has thrown out at me.
I've created a PHP tool for this; [URL="http://facepunch.com/showthread.php?t=1308430"]SQLite to MySQL Converter[/URL].
Just upload the sv.db to the tool and you should be good to go to import it to your MySQL server! =)
Funny thing is, I used that tool :p
Pastebin the converted code for me and I'll take a look at it.
File was too big for pastebin :P, so I put it here: [url]http://safeb.yt/ee29[/url]
Bump
Sorry, you need to Log In to post a reply to this thread.
