Trinitycore2 to Mangos

[Bogdan_012794]

Hi is there a way to transfer all the character+accounts from a trinity core2 to mangos?

Or if i have a trinitycore2 server, and i want to swich to mangos without wipe what should i doo?

Please help me, and try to teach me step by step, because this is the first time when i doo this.

Thanks

[Ashen]

it's the same.

you can create a script SQL by yourself with datasheet of the mangos database .

[Bogdan_012794]

well thanks, but i still kinda dont get it..

how should the script look like?

auth = realmd

character = character

world = wolrd

but the auth ; characters tables arent the same as the ones for mangos..i need the script..

can you help?

[The_Game_Master]

I made some experiements a few month ago, you can use mine, tweak it for your own use.

Trinity 9001 to MaNGOS 10267 character converter http://pastebin.com/QYLWbNz8

Enjoy!

[Electros]

i need help to convert item_instance (trinity 9530) to mangos 10431. this table originaly was changed in 9090, just, not know, how to match few collumns data to one...

http://pastebin.com/akdhwRfi tc 9530+

i renamed tc table to ..._old and inserted mangos table, this is almost working, just, not know, how to add space between guid and creatorguid in concat function

replace into item_instance (`guid`,`owner_guid`,`text`,`data`)

select guid,owner_guid,`text`,concat(guid,`creatorGuid`,`giftCreatorGuid`,`count`,`duration`,`charges`,`flags`,`enchantments`,`randomPropertyId`,`durability`,`playedTime`,`text`) from item_instance_old;

[skywalky]

Yo can try this:

replace into item_instance (`guid`,`owner_guid`,`text`,`data`)
select guid,owner_guid,`text`,concat(guid,' ',`creatorGuid`,' ',` giftCreatorGuid`,' ',`count`,' ',`duration`,' ',`charges`,' ',`flags`,' ',`enchantments`,' ',`randomPropertyId`,' ',`durability` ,' ',`playedTime`,' ',`text`) from item_instance_old;

But i don't know if it works.

[SkyAngel]

Pleas Update Trinity rev 10326