Changing my DB Plz help me!

07/24/2009 19:32 badboy r4c3r#1
ok so i want to change my DB but would like to keep all the following:
Accounts,Legions,Eudemons,businees partners and Family

which part of my existing db would i need to keep and if u think i would require to keep anything else.
07/24/2009 21:34 connorbacon99#2
for changing your database its rather tricky haha

Dump your cq_account table to keep the existing accounts (some accounts only work with some databases so your account folder now might not work with the new one)

if you are wanting to keep eudemons i wouldnt recommend it because that would require you to keep your cq_user table...otherwise the rankings would be useless haha and the problem with keeping the cq_user is that you need to manually configure the accounts to their characters...quite alot of work.

basically saying the only table really worth keeping in a database switch is your cq_account in my opinion.

keeping legions, eudemons, business partners, and families would all require you to have the existing users.

switching databases causes for tons of work on the owners side in compensating (if you are planning on compensating for losses) so just keep that in mind. good luck hope that helped haha
07/24/2009 21:54 badboy r4c3r#3
there must be away to copy the required info and then insert into the new db
Example my Db cq_eudemon, cq_user, account, extract them to batch files and then run in the new db, will this work?
07/24/2009 22:51 DEADP00L#4
it might but just remember you will have to check the file structure of the new database to make sure it matches with your old database otherwise it will cause major issues.
07/24/2009 23:02 badboy r4c3r#5
Quote:
Originally Posted by DEADP00L View Post
it might but just remember you will have to check the file structure of the new database to make sure it matches with your old database otherwise it will cause major issues.
both Db are are structured in the same way, which information is most important to carry over to the new 1 then.
07/25/2009 00:34 DEADP00L#6
you would then sql dump the tables you wish to save, then completely switch over the database to the new one. then exicute the sql dumps
07/25/2009 00:43 forcer#7
nothing is more easy than renaming the directory with your old db to my_old for example and doing left-join insert-select on new my folder you created.
[Only registered and activated users can see links. Click Here To Register...]

here comes the query:
Code:
insert into my.cq_user
select * from my_old.cq_user old 
left join my.cq_user new on new.id = old.id
where new.id = null
you can use this on all tables that hold user data like cq_eudemons, cq_item, cq_...
07/25/2009 01:29 badboy r4c3r#8
i undersatnd what forcer is saying but i need help in what to keep from the old db, so i can have same legion,account,family,euds,donations,pet ranks,friends,bussiness partners,and users.
07/25/2009 02:52 DEADP00L#9
thanks forcer...lol i honestly never knew that one.