Database Merging

[nasagnilac]

Question: Is it possible that I can merge my 2 different server items,accounts and characters?

Can please give me a tips how I can do it?
 

[Jaycee KyD]

Here's an outline of what you have to do:
1. decide which database is the "main" one, and which is being merged into the main one.
2. check the "main" ragnarok databse and find out the highest account_id, char_id, and any other indexs
3. then in the database that you will merge into the "main" one, you need to run queries to increase the account_id, char_id, and any other important indexes.
Example: account_id 2000001 + 3000000 = account_id 5000001
4. do all those queries on each table where `account_id` appears
5. repeat for `char_id`, etc etc (this solves the problem of duplicate indexes)
6. also repeat this for duplicate login names and char names
(ex: if there is a login "test" in your main database, and also a login "test" in the 2nd database
you could run a query to add a 2 to the end of all duplicates --> "test2"
7. and do something similar for duplicate char names
8. now you can just merge that database into your "main" one

http://www.eathena.ws/board/index.php?showtopic=237661&st=0&p=1296053entry1296053