Issues importing data to MySQL DB with pointshop

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:


SQL query:

INSERT INTO  `pointshop_data` 
VALUES (

'993283467',  '260',  '[]'
);

MySQL said: Documentation

#1062 - Duplicate entry '993283467' for key 'PRIMARY' 

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; SQLite to MySQL Converter.

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 :stuck_out_tongue:

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: http://safeb.yt/ee29

Bump