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