Mir2 2.3 Server Files

[Nicky]

What do I call the Databases?

 

[ILovePie:D]

What do I call the Databases?

the same as the db files, if ur restoring lom2account

create a new db called that and restore lom2account to it

the same with the rest

 

[Nicky]

the same as the db files, if ur restoring lom2account

create a new db called that and restore lom2account to it

the same with the rest

Ah right great help so I dont call them

We now go Into the Various Database you need to restoring in Order for the 3G Server to run:
A. In the Restore as Database for EACH One you type as Follows:
Account
ConLog
CruelDragon3GbaseData
Game3G
Hero3G
Manage
B. Now

As liquidSilver says, someone said follow all that because its exact :P​

 

[ILovePie:D]

Ah right great help so I dont call them

We now go Into the Various Database you need to restoring in Order for the 3G Server to run:
A. In the Restore as Database for EACH One you type as Follows:
Account
ConLog
CruelDragon3GbaseData
Game3G
Hero3G
Manage
B. Now

As liquidSilver says, someone said follow all that because its exact :P​

naa, just gives u a rough idea how to setup sql lol

 

[Nicky]

naa, just gives u a rough idea how to setup sql lol

Ah thanks with LOM2Market

It shows no back-up to restore, is that right?

 

[Hazuki]

Nicky, click the options tab, make sure that path is availble.

/Haz

 

[Nicky]

Thats all when I click Options on LOM2Market

 

[ILovePie:D]

Ah thanks with LOM2Market

It shows no back-up to restore, is that right?

Just do it as nightwolf said, pretty straight forward, no need to change any options whilst restoring, i couldn't tell you exactly what ur doing wrong and right now though cause i gave up trying to install them cause my dbsvr was closing, not reformatting just cause of that

easy as pie best thing todo is use the LOM2007Demo(SQL2000).rar version
and in SqlMir2\Mud2\DataBase create those dbs

LOM2Account
LOM2Game
LOM2Manage
LOM2Market
LOM2Res

and then restore them to the correct db

then you see the SqlMir2.reg edit as you see fit with usernames and passes and click it to enter those details in to the reg also there other txt files !DBSql.txt and !DBSetup.txt make sure those details are also correct

 

[Robert]

Right heres the least comprhensive guide you will ever read BUT it works.

~How to restore the dbs, and idiots guide

1.Open Up Enterprise Manager like so :

2.Click the [+] signs down on the left untill you reach this outlook.

3. Click the [+] again on Databases and you will see this, minus the mir2 bits obviously as we havent got there yet.

4.Next Right click on databases>NewDatabase, If you do so a window will appear like so:

5. Now type into the space LOM2Account and press ok.

6.After making the Database right click it >alltasks>restoredb and this window will appear

7.Click from device and link it to LOMAccount.Dat Then go to options and force restore over existing database, then ok it all and voila you have linked the first database, repeat these steps for all of the .dat files.

 

[Nicky]

Correct me on this:
; BDE Alias Name
ALIAS NAME=SqlMir2DB
; GOLD NAME DIFFERENT COUNTRY
GOLDNAME=coins
; Name or IP
SERVER NAME=Evolution
; Resource DataBase Name
DATABASE NAME=LOM2Res
; DB Owner's User Name
USER NAME=sa
; Password
PASSWORD=(my password)
;Tabel Names
TABLE_STDITEMS=RES_STDITEMS
TABLE_MONSTER=RES_MONSTER
TABLE_MOBITEM=RES_MOBITEM
TABLE_MAGIC=RES_MAGIC

EDIT: Beard I done that, it shows no restore for market.

 

[Robert]

In server name put (local) not your mir servers name.

Nicky did you setup odbc afterwards?

 

[Nicky]

So:
; DB Owner's User Name
USER NAME=sa
; Password
PASSWORD=iloveyou

is ok?
kk great now what about LOM2Market, it shows no backup when I added it.

 

[Robert]

if thats your username and password that you defined with sql when you set it up then yes indeedy.

Im not sure on that, it should work just like the others do, markets no different.!

 

[Hazuki]

Id recommend removing that password Nicky if it is your sa pass.

/Haz

 

[Nicky]

Errors love me always

Help please?

 

[Hazuki]

Name on DBServer = Servername.

/Haz

 

[Nicky]

Name on DBServer = Servername.

/Haz

Must I setup HeroDB Aswell?

 

[Robert]

Yep change that and run in rungate>selgate>logingate>loginserv>dbserv>m2 and your server will work

EDIT no need to setup herodb its obselete

 

[Nicky]

Ok all is fine except M2 mate

Legend of Mir 2007 Pre-Release Demo Version 60705
(C) Ragnarok ,All rights reserved.
http://www.game863.com
[ÕâÖ»ÊÇÑÝʾ°æ,×÷Õß²»Îª´Ë³Ðµ£ÈκÎÔðÈÎ]
ÔÊÐí×î¸ßµÈ¼¶:65535
ÔÊÐí×î¸ß·ÀÓù:65535
ÔÊÐí×î¸ßħÓù:65535
ÔÊÐí×î¸ß¹¥»÷:65535
ÔÊÐí×î¸ßħ·¨:65535
ÔÊÐí×î¸ßµÀÊõ:65535
=============ÑÝʾ°æ¹¦ÄÜÏÞÖÆ=============
ÔÊÐí×î¸ßµÈ¼¶:34
ÔÊÐí×î¸ß·ÀÓù:70
ÔÊÐí×î¸ßħÓù:70
ÔÊÐí×î¸ß¹¥»÷:100
ÔÊÐí×î¸ßħ·¨:80
ÔÊÐí×î¸ßµÀÊõ:80
²»Äܱ£´æÈËÎï
ÈκÎÈËÉÏÏ߶¼ÊÇGM
========================================
ready to load ini file..
!setup.txt loaded..
loading client version information..
Ok. Mir2.dat(1000218078) (0) (0)
loading StdItem.DB...
starttimer exception...
Not ready 127.0.0.1
Not ready 127.0.0.1
Not ready 127.0.0.1


Thx for help everyone

EDIT: RUNEGATE IS NOT CONNECTING Can anyone help please :P

 

[Killmaster]

where abouts are the dat files because all i have is .bak files in my database folder?

Do i have to create them? or am i looking in the wrong place?