Server Merge

[PSGB]

I try search on forum, but without sucess.

I have 2 server (low and high). I like merge this 2 server on 1.

How I can make this merge (charId, items etc) without duplicate errors?

Have any script for server merge?

Thx

[PSGB]

Nobody?

[Szponiasty]

Nobody?

There's no such thing, or at least not shared publicly. U can do it urself if u know what and how to do (or hire someone to do it for u )

[Gnacik]

It's quite simple. on one server make query to update charid and itemid in all tables. check min and max values, if for example charId=charid+100000000 is enough. Then export that db and import to first one, just simple insert without droping table or smth.

[kazike]

Add a number before the ID.

Id's from server high -> 1xxxxxx ("xxxxxx" is the original ID)
Id's from server low -> 2xxxxxx ("xxxxxx" is the original ID)

[Naminator_X_]

It's quite simple. on one server make query to update charid and itemid in all tables. check min and max values, if for example charId=charid+100000000 is enough. Then export that db and import to first one, just simple insert without droping table or smth.

Actually if both databases are on the same machine its as easy as INSERT INTO (SELECT) ON DUPLICATE KEY update id=id+1 mega easy and this is for every character info table

The bigger issue is with duplicate names and maintaining relativity for items owned by players/warehouse/mails.
It can be done you sure must have a backup and be able to write scripts (php, python, simple java apps etc)