Database on Ascent

[Kween]

I'm a little confused with the database part of the server. I have downloaded:

-Ascent 3430
-Character DB (2.3.0 Full) (12/16/07)
- NCDB 1006

from [Ascent] Daily Updates - Server files [23/01/08]

Now my question is, in which order would I import the sql into the database? Or does the order not matter? I've also read certain places something about world database. Is NCDB 2006 the world database or am I missing those files still? And lastly, Ascent 3430 has a folder called Sql-queries with some SQL files in there. Do those also need to be loaded in as well? If so, in which order?

[MentaL]

[msclecar]

I think I'm having the same problem as you. I extracted my own maps with the tool, so I didn't download the maps + batch file.

[meizme]

i am having the same issues

[msclecar]

I think I figured it out. Just download that NCDB thing. But after you edit your username and passwrd, you get problems about these lines:

set wdb=CHANGEME
set cdb=CHANGEME

I tried setting them to "localhost" but it didn't work.

[rkod420]

Sql queries are updates, run them.

Import them from lowest number, to highest.

NCDB is the world database.


Set them to tje WDB name... and CDB name...


W = world

C = character

[Raptress]

The batch file in the NCDB will extract the world files you need, so yes, NCDB is where the world database is coming from.

Make sure you've created your world and characters databases in SQLyog. Right-click on characters, and restore from SQL dump. Browse to your characters.sql file and execute that. That'll give you your characters database tables.

For the world DB, edit the batch file in NCDB and replace the username/password with the username/password on your MySQL server. Run it and tell it to extract the files. If done correctly, it should put all the files the world database needs in the world database.

As for the SQL-queries folder, I'm not sure as I'm running 2554 and it doesn't have that folder. If it is like the SQL Updates folder though, I don't think it matters in which order you run them.

[msclecar]

Alright I figured it out. This:

set wdb=CHANGEME
set cdb=CHANGEME

to

[code]

set wdb=world
set cdb=characters

The text after the "=" is just the name of the database.

[msclecar]

For some reason I get disconnected after making a character (can't make a character)

[rkod420]

Alright I figured it out. This:

set wdb=CHANGEME
set cdb=CHANGEME

to

[code]

set wdb=world
set cdb=characters

The text after the "=" is just the name of the database.

You figured it out? I just goddamn posted that.

[Juggalo90]

msclecar...
Try running some SQL updates...