[GUIDE] How to migrate accounts & characters to latest VIP Version /Save accs & chars

[Blackvision]

Dumped the new db mop_world to file

now just trying to find where to actually import.

Can't remember how Heidi works.
Im using navicat

 

[Blackvision]

Dumped the new db mop_world to file

now just trying to find where to actually import.

Can't you right click on the world db, should say somethin about import ?

 

[secret]

Can't you right click on the world db, should say somethin about import ?

nope. but i found it

 

[Blackvision]

nope. but i found it

glad you figured it out

 

[Gnarlsbarkly]

I hate to be THAT noob but how to i execute steps 12 and 13 in hedi SQL?

(EDIT) Nevermind Figured it out

 

[MrBonesX420]

Hello, NOOB here,
How do I "12) Execute this into your Char DB:" ?

 

[Sikuri]

Hello, NOOB here,
How do I "12) Execute this into your Char DB:" ?

Pretty sure you click to select the MOP_Characters table on the left, then execute the SQL queries by clicking the blue play button and running.

 

[styfos]

Hi,

i was asking myself, why don`t just create a new world.db. Therefor u only have to do the Dump & Import once.
In the worldserver.conf, you can simply change the world db connection like:


# Default: "127.0.0.1;3306;root;ascent;emucoach_v12_vip_auth" - (LoginDatabaseInfo)
# "127.0.0.1;3306;root;ascent;emucoach_v12_vip_world" - (WorldDatabaseInfo)
# "127.0.0.1;3306;root;ascent;emucoach_v12_vip_char" - (CharacterDatabaseInfo)

LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;emucoach_v12_vip_auth"
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;emucoach_v17_vip_world" <-- simply edit the world db connection string
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;emucoach_v12_vip_char"

In the DB Tool, you will then have both worlds. The new and the old version ~ my 2 cent

 

[klodeckel23]

nice tutorial ... hope I do the steps correctly ^^

 

[hellfire7912]

Hi,

i was asking myself, why don`t just create a new world.db. Therefor u only have to do the Dump & Import once.
In the worldserver.conf, you can simply change the world db connection like:


# Default: "127.0.0.1;3306;root;ascent;emucoach_v12_vip_auth" - (LoginDatabaseInfo)
# "127.0.0.1;3306;root;ascent;emucoach_v12_vip_world" - (WorldDatabaseInfo)
# "127.0.0.1;3306;root;ascent;emucoach_v12_vip_char" - (CharacterDatabaseInfo)

LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;emucoach_v12_vip_auth"
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;emucoach_v17_vip_world" <-- simply edit the world db connection string
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;emucoach_v12_vip_char"

In the DB Tool, you will then have both worlds. The new and the old version ~ my 2 cent
View attachment 2826

looking at the auth-db scripts, there are certain changes made to the structure, so you'll need to apply these as well.
BUT i'd rather dump to a file, instead create a new named DB and export directly to this. the steps for the scripts will remain the same of course.

 

[LostBoyJoey]

Tyty, this is awesome....i even figured it out and thats saying something