[QUESTION] HOW TO MERGE 2 DATABASE INTO 1

I wonder if 2 databases can merge into 1 database, I mean it at cq_action section. and I know it may cause an error for some id. anyone has did it before?

I believe eujin owner has posted this problem a long time ago, but I can't find that post again. and I am not sure it has been solved or not.

Why you want to merge a cq_action?

Not only the ID has to match the items/NPCs etc...
also, cq_task and others tables have to be adjusted.

Best to manual transfer this to avoid bugs and stuff.

For players, you might want to change the account ID and player ID in ALL tables, this way you can "add" those easy in your other database. However, make note to duplicated user login names.

I know this answer is not a quick fix... but I honestly think this is the best option to "merge" 2 databases together.

are you trying to run 2 servers off of this 1 DB? or just make a DB for 1 server?