- Joined
- Sep 9, 2008
- Messages
- 1,052
- Reaction score
- 475
First know that. Only 20% of this guide goes to me since I did not know how to this if it wasn't for my friend. And next. It's because the SQL query was not made by me.
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:
8.Test your accounts. If it's not done correctly restore your old database and refer back to the guide.
Note: Items may not be kept.
A little guide for beginners. I needed this back then also. Too bad I couldn't find a guide. I was lucky to have a friend that knew it lol.
Credits:
Milamber
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:
Code:
Insert Into MEMB_INFO ( memb___id, memb__pwd, memb_name, sno__numb, post_code, addr_info, addr_deta, tel__numb, phon_numb, mail_addr, fpas_ques, fpas_answ, job__code, appl_days, modi_days, out__days, true_days, mail_chek, bloc_code, ctl1_code) Select MEMB_INFO2.memb___id, MEMB_INFO2.memb__pwd, MEMB_INFO2.memb_name, MEMB_INFO2.sno__numb, MEMB_INFO2.post_code, MEMB_INFO2.addr_info, MEMB_INFO2.addr_deta, MEMB_INFO2.tel__numb, MEMB_INFO2.phon_numb, MEMB_INFO2.mail_addr, MEMB_INFO2.fpas_ques, MEMB_INFO2.fpas_answ, MEMB_INFO2.job__code, MEMB_INFO2.appl_days, MEMB_INFO2.modi_days, MEMB_INFO2.out__days, MEMB_INFO2.true_days, MEMB_INFO2.mail_chek, MEMB_INFO2.bloc_code, MEMB_INFO2.ctl1_code from MEMB_INFO2
Insert Into AccountCharacter (Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC) Select AccountCharacter2.Id, AccountCharacter2.GameID1, AccountCharacter2.GameID2, AccountCharacter2.GameID3, AccountCharacter2.GameID4, AccountCharacter2.GameID5, AccountCharacter2.GameIDC from AccountCharacter2
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
Insert Into MEMB_STAT ( memb___id, ConnectStat, ServerName, IP, ConnectTM, DisConnectTM) Select MEMB_STAT2.memb___id, MEMB_STAT2.ConnectStat, MEMB_STAT2.ServerName, MEMB_STAT2.IP, MEMB_STAT2.ConnectTM, MEMB_STAT2.DisConnectTM from MEMB_STAT2
Insert Into warehouse ( AccountID, Items, Money, EndUseDate, DbVersion, pw) Select warehouse2.AccountID, warehouse2.Items, warehouse2.Money, warehouse2.EndUseDate, warehouse2.DbVersion, warehouse2.pw from warehouse2
Insert Into VI_CURR_INFO ( ends_days, chek_code, used_time, memb___id, memb_name, memb_guid, sno__numb, Bill_Section, Bill_Value, Bill_Hour,Surplus_Point, Surplus_Minute, Increase_Days) Select VI_CURR_INFO2.ends_days, VI_CURR_INFO2.chek_code, VI_CURR_INFO2.used_time, VI_CURR_INFO2.memb___id, VI_CURR_INFO2.memb_name, VI_CURR_INFO2.memb_guid, VI_CURR_INFO2.sno__numb, VI_CURR_INFO2.Bill_Section, VI_CURR_INFO2.Bill_Value, VI_CURR_INFO2.Bill_Hour, VI_CURR_INFO2.Surplus_Point, VI_CURR_INFO2.Surplus_Minute, VI_CURR_INFO2.Increase_Days from VI_CURR_INFO2Note: Items may not be kept.
A little guide for beginners. I needed this back then also. Too bad I couldn't find a guide. I was lucky to have a friend that knew it lol.
Credits:
Milamber
