Acasa
![[Guide]Migrare database Empty](https://2img.net/i/empty.gif)
1.Backup baza de date deja existenta, MuOnline
2.Acum dati delete la database MuOnline(pentru redenumirea) şi de a face o nouă bază de date numita "MuOnline2"
3.Faceti restore la database in MuOnline2 (cea ce inseamna ca vechea ta baza de date este acum MuOnline2)
4.Creati un nou database numit MuOnline si facetii restore cu season 3 episode 2.bak
5.Acum redenumiti acestea:
in MuOnline2: MEMB_INFO, AccountCharacter, Character, MEMB_STAT, warehouse, VI_CURR_INFO
Redenumiti`le cu MEMB_INFO2, AccountCharacter2, Character2, MEMB_STAT2, warehouse2, VI_CURR_INFO2.
6.
Utilizaţi următorul meniu din Enterprise Manager atunci când deschideţi tabele in MuOnline2: All tasks -> Export data.
Apasati next de 2ori, select New DB - MuOnline, Next twice, Select tables "MEMB_INFO, AccountCharacter, Character, MEMB_STAT, warehouse, VI_CURR_INFO", Next twice, Finish.
7.Odată ce tabelele nu sunt finalizate cu erori. Rulati acest query:
8.Testati accounturile. Daca nu este facut corect restore vechiul database.
Nota: Itemele nu pot fi ţinute.
Un mic ghid pentru incepatori.
2.Acum dati delete la database MuOnline(pentru redenumirea) şi de a face o nouă bază de date numita "MuOnline2"
3.Faceti restore la database in MuOnline2 (cea ce inseamna ca vechea ta baza de date este acum MuOnline2)
4.Creati un nou database numit MuOnline si facetii restore cu season 3 episode 2.bak
5.Acum redenumiti acestea:
in MuOnline2: MEMB_INFO, AccountCharacter, Character, MEMB_STAT, warehouse, VI_CURR_INFO
Redenumiti`le cu MEMB_INFO2, AccountCharacter2, Character2, MEMB_STAT2, warehouse2, VI_CURR_INFO2.
6.
Utilizaţi următorul meniu din Enterprise Manager atunci când deschideţi tabele in MuOnline2: All tasks -> Export data.
Apasati next de 2ori, select New DB - MuOnline, Next twice, Select tables "MEMB_INFO, AccountCharacter, Character, MEMB_STAT, warehouse, VI_CURR_INFO", Next twice, Finish.
7.Odată ce tabelele nu sunt finalizate cu erori. Rulati acest query:
- Cod:
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_INFO2
8.Testati accounturile. Daca nu este facut corect restore vechiul database.
Nota: Itemele nu pot fi ţinute.
Un mic ghid pentru incepatori.
