[Question]Merging ?

10/22/2010 07:47 T.h.u.n.d.e.r#1
Hey guys i wander if is it possible to merge account , legions and pets ect.. from adb to another ?
10/22/2010 10:03 DEADP00L#2
as long as the fields are all the same yes you can merge them. just be careful
10/22/2010 17:07 King_Arthur#3
It's 100% possible, even TQ managed to do it when they merged Sidney with Toronto ;) But be prepared to do lots of troubleshooting if you try it. There are lots of unique and auto-incrementing fields that might need adjustment. As always, backup, backup, BACKUP! :awesome:
10/22/2010 21:59 SoulNecturn#4
Quote:
Originally Posted by SpongeBox View Post
kiddd, what have you been smoking? :mofo:
If I may...

King_Arthur has 110% right in every word he wrote...

I made as well merge of 2 DO servers - I merged brutal to extreme around 2 months ago (or something like that).
And like Kig_Arthur wrote - be prepared to do lots of troubleshooting and do backups...
I could add my own examples where I have to be careful and what I had to do by hand but this wont help much...
Will just suggest - make test DBs... sacrifice few hours for tests ... and depending how good you are in making fitting to actions like this queries you will get that good effect...

regards
10/22/2010 22:13 karnyge#5
Merging databases is covered by a stickied thread by knight^hawk.

You will find it here -http://www.elitepvpers.com/forum/eo-pserver-hosting/476848-guide-how-merge-your-main-databases-into-one.html

Dont know if it is what you were looking for, but it may help you.
10/22/2010 22:15 ~WARNING~#6
Quote:
Originally Posted by karnyge View Post
Merging databases is covered by a stickied thread by knight^hawk.
the only stickied threads are the rules(by DEADP00L), the all things guide(by ~*Dibiase*~), and the server list(by spy_dude2000).

on topic: yes it is possible to merge databases, but it requires a lot(and i mean a lot) of work to do.
10/23/2010 03:54 King_Arthur#7
Quote:
Originally Posted by karnyge View Post
Merging databases is covered by a stickied thread by knight^hawk.

You will find it here -http://www.elitepvpers.com/forum/eo-pserver-hosting/476848-guide-how-merge-your-main-databases-into-one.html

Dont know if it is what you were looking for, but it may help you.
This covers merging an account database and a my database into one my database. The think the OP wants to merge two account dbs into one account db and two my dbs into one my db.
10/23/2010 05:14 .Ash#8
Quote:
Originally Posted by SoulNecturn View Post
If I may...

King_Arthur has 110% right in every word he wrote...



regards
I know lol i should have been more clearly. i was talking about last part. lol the part where he was acting creepy..
10/23/2010 06:56 karnyge#9
Quote:
Originally Posted by King_Arthur View Post
This covers merging an account database and a my database into one my database. The think the OP wants to merge two account dbs into one account db and two my dbs into one my db.
Probably right there KA. Just trying to assist.