brumi
Newcomer
Joined: 15 Dec 2006
Posts: 55
Rank: +2 (2)
Location: ROMANIA
|
 Posted: Sun May 20, 2007 8:42 am Post subject: |
 |
|
|
its all good sorry to double post but its kinda not like double post i just post my own guide of transfering db.... i just remade translation its not actualy mine .... there were few english spelling .... problems i fixed it as much as i could and had time 
This guide was written by Khorr0 and just translated by me...Good job Khorr0
Good this guide is something noobish because I no longer have as much time like before perfecting my works. Of all ways I think that you need some other form or util.
First they need to do backup of its old data base.
We are going to use for example, that I have a Server 97d and I want to move data to a Version 1.1E
Well first, I do backup of my server 97. Now perform server MX 1.1E setup as bla must bla bla, and I recover new DB 1.1e in the data base Muonline truth? (like always)
Now I create another one db that is called Muonline2 and in this I recover my db 97d
In MuOnline2 change the following tables adding to them 2 in the end:
| Code: | AccountCharacter
Character
Guild *
GuildMember *
MEMB_INFO
MEMB_STAT
OptionData
VI_CURR_INFO
warehouse |
So that they are left as:
| Code: | AccountCharacter2
Character2
Guild2 *
GuildMember2 *
MEMB_INFO2
MEMB_STAT2
OptionData2
VI_CURR_INFO2
warehouse2 |
Now we are concerned with moving the information from the database of MuOnline97d to MuOnline that is new db as:
1.- We entered our enterprise manager of SQL
2.- we give to right click to the database MuOnline>All Tasks>Import Data
3.- Click next on the first window
4.- In second we leave everything as is and change the database to MuOnline2 being sure to enter your Sql Username and Password.
5.- the third window we did not touch except to change the SQL Username and Password.
6.- In the fourth window we choose ?Copy the table(s) and view(s) from source database?
7.- In the following window the tables and views you want to select are:
| Code: | AccountCharacter2
Character2
Guild2 *
GuildMember2 *
MEMB_INFO2
MEMB_STAT2
OptionData2
VI_CURR_INFO2
warehouse2 |
*It is not recommend to transfer the Guild and GuildMember tables however?do so at your own risk.
Once finished with the process we go to Start>All Programs>MS SQL Server> Query Analyzer, in the analyzer we initiated the session with the premises, Windows authentication. Inside we already choose above db with which it worked: Mu Online and we executed this script:
Now execute the following script immeaditly:
| Code: |
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
GO
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
GO
Insert Into Guild ( G_Name, G_Mark, G_Score, G_Master, G_Count, G_Notice)
Select Guild2.G_Name, Guild2.G_Mark, Guild2.G_Score, Guild2.G_Master, Guild2.G_Count, Guild2.G_Notice from Guild2
GO
Insert Into GuildMember ( Name, G_Name, G_Level)
Select GuildMember2.Name, GuildMember2.G_Name, GuildMember2.G_Level from GuildMember2
GO
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
GO
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
GO
Insert Into OptionData (Name, Skillkey, GameOption, Qkey, Wkey, Ekey, ChatWindow)
Select OptionData2.Name, OptionData2.Skillkey, OptionData2.GameOption, OptionData2.Qkey, OptionData2.Wkey, OptionData2.Ekey, OptionData2.ChatWindow from OptionData2
GO
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
GO
Insert Into warehouse ( AccountID, Items, Money, EndUseDate, DbVersion, pw)
Select warehouse2.AccountID, warehouse2.Items, warehouse2.Money, warehouse2.EndUseDate, warehouse2.DbVersion, warehouse2.pw from warehouse2
GO |
And ready we have db totally functional for the 1.1E
Remember That the database you want to use(the new database, like MX 1.1E in this example) must be totally clean with no users. Another thing if in the import of the database with I number 2 gives error to them: Table or something could not be transferred as, try it again but with only one table at a time continuing till all tables are done with no errors.
If somebody has errors of the following types:
"NOT true_days' can insert value NULL in the column '..etc
That is because these trying to put a value NULL of db old to one column that does not allow to value null in db new. Solution PERMIT the VALUE NULL to the column that gives the error to you, also you need put the value of it to NULL in to design table.
Another error is for example:
"NOT it can insert a row of keys duplicated in the object "OPTIONDATA" bla bla "
This is because the table option dates from new db has data for that reason it cannot to duplicate to existing data, you must totally have it in target
remaked by angels team kinda funny english re posted by brumi so thay wont say im an ass hole and i dont help >
brumi seas:
1 problem i had with transfer when i did from 97db to 1.0 db i lost the ranking i mean the toplist all characters remaned all shit items all but the reset ranking did not worke ... |
|
