Character import

[helpmeplz1984]

I need help, me and a friend both have the same Mangos server at home, and we both play wow alot, but we seem to have a problem. I know it is possible to backup a database of a specific server, and import it later. But is it possible for us to import our players seperately and play on the same server?

[MentaL]

[Darkicon]

Instead of backing up the entire server, just backup the account table, and import it.

[FamineMK]

backing up the account table from the realm DB will not get the characters over. It only brings over the accounts and passwords. The account table is only "Linked" to the character table (in the MaNGOS DB). Which is then linked to about 6 other tables that hold specific data about each character. (Items, guilds... the list goes on)

To the first post:
Let me get this right, you have two databases that you are trying to consolidate into one basically?

If that is the case you aren't going to be able to do it easily. Every time MaNGOS makes a new entry it does it incrimentally. So lets say you both have only one account on both servers. Now your account and players actually hold the same account ID that his account and players do. So in each of the tables that are linked together you have to change each ID on all characters linked to that account. Its like the first column of data for each character.

If this is the only account on the server, not really a problem to do, you can export each line as a comma separated value, save it to an "Excel" friendly format, mod it there and then take it to his PC. Then you could import it there as a CSV and if all the data was done right, you should have your toons and account on his PC.

Hope this helps, and I also hope it doesn't steer you clear of the challenge. Just need some direction on what lines to get, which I'm sorry to say I don't know which ones to get for you.

[helpmeplz1984]

We both have only one character, and one account. What u said is still not clear to me, can u maybe rephrase plz :D

I tried using navicat, but for some weird reason i`m not able to import the other table???

[MAXTRAXv4]

@FamineMK lol i can read it and understand it but next time make shure others can understand your "big" words(p.s. im not haveing "a go" at you)

oh what he sed was the account and the charr stuff have to be copyed becuse the account and charr have a linked code(so only you can have the charr if you have the account)

[FamineMK]

Perhaps I should type it this way.

Wen u copy all teh data ovr, there are a bunch of tables dat u need to get. Not just teh Account info from teh Realm DB. There is no easy way to do it.

Sorry to post such lengthy explinations.

[helpmeplz1984]

I used navicat imported my account, but lost my characters, which tables will i need to transfer to be able to play? It shows that i have a character but on retrieving it, it can`t be found???

[MAXTRAXv4]

auctionhouse
character
character_action
character_aura
character_homebind
character_inventory
character_kill
character_pet
character_queststatus
character_reputation
character_social
character_spell
character_spell_cooldown
character_stable
character_ticket
character_tutorial
guild
guild_charter
guild_charter_sign
guild_member
guild_rank
item_instance
mail
lfg_template
raidgroup
raidgroup_member