(MYACC) Merge 2 databases

[Maziajka]

Hello!

I was wondering what is the best way to merge 2 databases from 2 different servers? Or if that's even possible. So basically all characters/accounts from server A will merge to server B.

If any more information is needed lmk

 

[Ianoyo]

Considering that both databases are identical... the most obvious way would be to export the relevant database tables (data only) such as players, player_items to a schema. Then simply import to the target database.
(Note: If you are using PhpMyAdmin, beware of PHP's default timeout. It would be better to use an IDE such as HeidiSQL)

You will run into several problems such as conflicts of player names, misaligned account ids and more.

Therefore, I would programmatically do this via PHP or Python. I would iterate through each account and insert that first, then also insert each player for that account (whilst updating it with the new account id, resetting temple pos etc)...

The rest I will let you figure out.

 

[kimus1991]

Hello!

I was wondering what is the best way to merge 2 databases from 2 different servers? Or if that's even possible. So basically all characters/accounts from server A will merge to server B.

If any more information is needed lmk

So we have one main database, and the other one is to be migrated and not used again
Maybe this way if this only applies to accounts without items:
- Check the last AccountID in the main database (example 19000) and then execute the following on the one to be migrated:

UPDATE players SET account_id = account_id + 20000;
UPDATE accounts SET id = id + 20000;
UPDATE players SET name = CONCAT(name, ' transferred') WHERE name IS NOT NULL;

Then export and import two files it into your main database (it should react auto increment to add new rows)
Of course make a backup and save before trying this method

 

[vemvetvad]

Trying to merge two versions of Eriana together huh Lopek?

 

[Maziajka]

Trying to merge two versions of Eriana together huh Lopek?

I wish

 

[kimus1991]

I wish

So if you want to use two databases all the time and choose a character for a given server from the login panel - I left a private message