[ASKER_CZ]

I made my servers on SQLITE because i never thought it will be so popular. Now i have like 500k lines in database on each server, and have problems with that. Wanna migrate to MySQL. Can Somebody help me how to do it with 100% succes ? I can pay via PayPal. if you can help me, contact me here http://steamcommunity.com/id/smileisdabest

(im pretty sure this is wrong section, if yes then please move it. thanks)

[B3none]

Add me, we can discuss this.

[ASKER_CZ]

Refresh, still need it. I use ckSurf and anytime i try import .sql via phpmyadmin it says something like "WRONG SYNTAX" ...

[Arkarr]

Originally Posted by ASKER_CZ Refresh, still need it. I use ckSurf and anytime i try import .sql via phpmyadmin it says something like "WRONG SYNTAX" ...

Can you post the script here and also your database engine ?

[Lannister]

I'm looking foward this too, i've started using Store with SQLITE since i have small community with really few people, but, after some time i've found out that there's lots of lines there and the performance of my server started to decrease a little, also, some of the items started to get "stuck" on players, someone told me that it may be because i'm using Sqlite for a big plugin like Store.

I'm also looking foward someone to help me with this issue, and i also wonder if its actually possible to convert 100% a sqlite table to mysql without loosing something?

[ASKER_CZ]

Originally Posted by Arkarr Can you post the script here and also your database engine ?

and after .sql import i get this error :


Can anybody help me? Should i use different version of MySQL or what?

[Arkarr]

Problem is here because player name have a '\' char, wich is the escape character. (First line)
There is one simple solution wich consist of replacing each '\' char by a double '\' char.
So, instend of having :
'/\DmSTT/\'
You will need :
'/\\DmSTT/\\'
That's it. It's fixed.

EDIT:
In case you didn't know, there is a function for that in notepad++ :

[ASKER_CZ]

Thank you it worked.
BTW: Where is problem here?

And if you are interested to make it 100% work for 20€ then contact me in PM

[Arkarr]

It's the above line wich create problems.

[ASKER_CZ]

It's not. It looks like this. I've just cutted it.