Help with databases

[Mikal]

I'm trying to import lurker's npc spawn database into mysql and it's not populating the zones. Can someone post a step by step on how to do this?

Mikal

[devn00b]

open mysql.

type

use <insert yer db name here>
should say database changed
then type
source <insert file name here>

vala!

[Mikal]

And this will add the new database to the existing "eq" database that I compiled when I first started?

Mikal

[Trumpcard]

No, it will knock up your daughter and steal your car...


Yes, it will add the updates to the existing database...




IN a nutshell:

use : use this database
so ,
use eq;
means use the existing eq database that you should have already sourced (not compiled btw, importing a database has nothing to do with compiling)

source <file>;
means populate my database that I picked above with this datafile.

[Lurker_005]

Or just use the batch file I included in the download. It allows you to add the files to an existing DB or create a new DB.

Also keep in mind not all Velious or Lucin zones are populated. I think all the old world and Kunark zones have at least some spawns.