How to bring your old DB over to new Ver. DB files

[HellSing]

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:

 
AccountCharacter
Character
Guild *
GuildMember *
MEMB_INFO
MEMB_STAT
OptionData
VI_CURR_INFO
warehouse

So that they are left as:

 
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:

 
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:

 
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

[MentaL]

[Svaike]

nice, but as you write it is guide:)

[HellSing]

ops im sorry i think that i was in the guides section.. sorry..

[Svaike]

ops im sorry i think that i was in the guides section.. sorry..

you may delte thrad and open new thread in guide section:) anyway that is very usefull^^

[Spellior]

But how move DB from 1.02d ver. to 0.99.62T?

[[/root.]]

But how move DB from 1.02d ver. to 0.99.62T?

Good Question

[javaz97]

DECLARE @rank int
SET @rank = 0
WHILE @rank < 2513 --Number OF row


BEGIN
update MEMB_INFO
set memb_guid = @rank, @rank = @rank + 1
--SET @rank = @rank + 1
--order by memb___id asc

END

** Query to Resort memb_guide

Please check relationship
new db change all table

Create Table and value resort Match all table and fix ect...
try doing and fix yourself

[lopko]

is this guide working for transfering acc and charracters from 1.02d to 1.02I????pls tell me!

[1Word]

i think so lopko ...

[lopko]

i think so lopko ...

ok i will try!

[limpbizket]

i dont exsakly understand :S just need to backup 97d version db put in the 1.01e server files restore like new in SQL manager and write script in the old one db?

[RedMG]

Nice but I think you shouldpost it in Guide, Thx

[noporeao]

Nice.. good job..:3dflagsdo

[Svaike]

1 big mistake when restoring 97d to 1.01E :) in 97d plate set, in 1.01E much more better:D remember that items codes differs, so better to clean inventory and vault

[JoKeR007]

i wana change my server to ver 1.0L i do all steps on here but i got this error

Server: Msg 2627, Level 14, State 1, Line 1 
Violation of PRIMARY KEY constraint 'PK_AccountCharacter'. Cannot insert duplicate key in object 'AccountCharacter'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_Character'. Cannot insert duplicate key in object 'Character'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_Guild'. Cannot insert duplicate key in object 'Guild'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_GuildMember'. Cannot insert duplicate key in object 'GuildMember'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_MEMB_INFO'. Cannot insert duplicate key in object 'MEMB_INFO'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_MEMB_STAT'. Cannot insert duplicate key in object 'MEMB_STAT'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_OptionData'. Cannot insert duplicate key in object 'OptionData'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_VI_CURR_INFO'. Cannot insert duplicate key in object 'VI_CURR_INFO'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_warehouse'. Cannot insert duplicate key in object 'warehouse'. 
The statement has been terminated. 

also in the webpage and mueditor show no accs (0 accounts)
i tryed alot ...same error

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

can some 1 explan this :this is my problem but i dont undertsnad it..

[Fedayeen]

i wana change my server to ver 1.0L i do all steps on here but i got this error

Server: Msg 2627, Level 14, State 1, Line 1 
Violation of PRIMARY KEY constraint 'PK_AccountCharacter'. Cannot insert duplicate key in object 'AccountCharacter'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_Character'. Cannot insert duplicate key in object 'Character'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_Guild'. Cannot insert duplicate key in object 'Guild'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_GuildMember'. Cannot insert duplicate key in object 'GuildMember'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_MEMB_INFO'. Cannot insert duplicate key in object 'MEMB_INFO'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_MEMB_STAT'. Cannot insert duplicate key in object 'MEMB_STAT'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_OptionData'. Cannot insert duplicate key in object 'OptionData'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_VI_CURR_INFO'. Cannot insert duplicate key in object 'VI_CURR_INFO'. 
The statement has been terminated. 
Server: Msg 2627, Level 14, State 1, Line 2 
Violation of PRIMARY KEY constraint 'PK_warehouse'. Cannot insert duplicate key in object 'warehouse'. 
The statement has been terminated. 

can some 1 explan this :this is my problem but i dont undertsnad it..

ummm.... same error :(

[creasy]

tengo el mismo error pero con el register.php de Mutoolz 2.3 md5 GRRRRRRRRRRRRR HELP PLZZZZ

[mig1st4ck]

Guys there is a simple and easy soluction.

just do the script like this.

DELETE FROM [MuOnline].[dbo].[Character]
INSERT INTO [MuOnline].[dbo].[Character]([AccountID], ... [Reset])
SELECT [AccountID], ... [Reset]
FROM [MuOnline1].[dbo].[Character]

Simple. and you don't need to change character to character2 or copy to the same database.
Also the "DELETE FROM [MuOnline].[dbo].[Character]" will erase all lines in character.
now plz make sure that all the tables mach.
the insert must be like the select.

now do that to all the tables mencioned in theath.

PS: to do this easy. in sql query on the Collum letf there is all the databases go to the disired and open it its like a tree. so when you get the disired table, right click on it and Sript object in new window as insert or select.
this will create all the codo you need.

[kikosala]

But.... trying from 1.1e version to 1.2i version.... is need to clean all baults, inventory's and sets from all characters???
I have a lot of acounts and every body have their items....

Can I with this method save the items of the acounts?

[mig1st4ck]

But.... trying from 1.1e version to 1.2i version.... is need to clean all baults, inventory's and sets from all characters???
I have a lot of acounts and every body have their items....

Can I with this method save the items of the acounts?

you can save everyting. but make sure the versions is compatible. like in 1.02d unila was fenir so if it change to other version they get unila and not fenir. stuff like this can happen.

to pass all the things. just keep the idea.

insert is the new database. it should be clean, or you can have trobles.
select for the old database.

[jlroco33]

Hellsing and what about memb__pwd ??? md5 ???

Algo de info sobre como pasar a MD5 (en Espa&#241;ol/Spanish)
Click Aqui

For change old memb__pwd <--- to a Md5 ---> memb__pwd
you copy all olds memb_pwd to memb_pwd2 first and do this:

DECLARE @lin1 varchar (16), @lin2 varchar (16)
UPDATE MEMB_INFO
SET @lin1=memb__pwd2, @lin2=memb___id, memb__pwd = dbo.fn_md5(@lin1, @lin2)
WHERE memb___id = memb___id


and for memb_info in column memb_guid with all 1 and not a number like in AccountCharacter execute this:

UPDATE dbo.MEMB_INFO
SET dbo.MEMB_INFO.memb_guid=dbo.AccountCharacter.Number
FROM MEMB_INFO JOIN AccountCharacter ON AccountCharacter.Id = MEMB_INFO.memb___id
WHERE AccountCharacter.Id=MEMB_INFO.memb___id

[AlexandriaTeam]

groso gracias capo!!!
tanks alot dud!!
:fire: :fire: :fire: :fire:

[jlroco33]

Is posible what this problem is a duplicate mail address, Verify every mail, and change... order by column mail first...

[UnForSaken]

you know its a lil late...but now that I look at this thread I noticed this...you stole this original post word for word from my post dated nearly 3 monthes before your post on CzF forum...which is where kchorr0 posted his guide. If your gonna post threads from other ppls forums...at least give credits to where they are due...

[Loks]

can i use this guide for changing version 1.02d to 1.02k???