From Season 3 to Season6 database

[chenzhen]

Database Migration

1.Backup your existing database, MuOnline
2.Now delete your MuOnline database(for renaming) and make a new database called "MuOnline2"
3.Restore your back'd up database into MuOnline2 (Means your old database is now in MuOnline2)
4.Create a new database named MuOnline and restore with the season 3 episode 2.bak
5.Now rename these:
in MuOnline2: MEMB_INFO, AccountCharacter, Character, MEMB_STAT, warehouse, VI_CURR_INFO
Rename them to MEMB_INFO2, AccountCharacter2, Character2, MEMB_STAT2, warehouse2, VI_CURR_INFO2.
6.Use the following menu in Enterprise Manager when you open tables in MuOnline2: All tasks -> Export data.
Press Next twice, select New DB - MuOnline, Next twice, Select tables "MEMB_INFO, AccountCharacter, Character, MEMB_STAT, warehouse, VI_CURR_INFO", Next twice, Finish.
7.Once your tables are completed with no errors. Run this query:

GUIDE from here: the scrips run ok except character
http://forum.ragezone.com/f196/datab...ration-500788/

Insert Into Character (AccountID, Name, cLevel, LevelUpPoint, Class, Experience, Strength, Dexterity,Vitality, Energy, Inventory, MagicList, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, MDate, LDate, CtlCode, DbVersion, Quest) Select Character2.AccountID, Character2.Name, Character2.cLevel, Character2.LevelUpPoint, Character2.Class, Character2.Experience, Character2.Strength, Character2.Dexterity,Character2.Vitality, Character2.Energy, Character2.Inventory, Character2.MagicList, Character2.Money, Character2.Life, Character2.MaxLife, Character2.Mana, Character2.MaxMana, Character2.MapNumber, Character2.MapPosX, Character2.MapPosY, Character2.MapDir, Character2.PkCount, Character2.PkLevel, Character2.PkTime, Character2.MDate, Character2.LDate, Character2.CtlCode, Character2.DbVersion, Character2.Quest from Character2

Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.

account ok
character no character from old season.



i try to modified the character table of season3 and add some colum from season6 character table.
and that table i use.

account ok
character ok

the problem is cant reset from website.
after disconnect/select character etc. acount rollback.

how to fix

[MentaL]

[KarLi]

You should re-do it or find other tutorial since the query doesnt work.