4.0 DB TROUBLE!!! VERY SERIOUS!!!

Slayer02 · #1 12-09-2002, 11:17 AM

Ok im new to all this, I used to play awhile back (I used to run The Necropolis, I still do, but Im having a problem) I got everything the way I want it to be except, There are no items or spawns in the database that came with the emu I downloaded!!! (4.0) where can I get a db that has the majority of the spawns/items loaded??? Plz someone help!

flipper · #2 12-09-2002, 11:23 AM

You should start with the 0.3.13 database, then add in the DB-Addon from 0.3.13. After that use the dbupdate.sql that is included in 0.4.0 and you'll be ready for fun. You should also do the 'Cleaned spawn database' thing that is listed on the eqemu.net main page.

Pneu · #3 12-09-2002, 11:26 AM

I have a pretty much fully featured database I can send you with all the items and spawn groups - but no spawn locations (FqAdmin Spawns/Spawns menu is empty). It's just over 2mb if you want it.

Let me know if you want email or if I should post to my rather lousy ftp site.

Pneu

Slayer02 · #4 12-09-2002, 01:10 PM

Ill try the 0.1.3.03 whatever thing first, if that dosen't suit my needs ill let you know

Slayer02 · #5 12-09-2002, 01:40 PM

Ok the db thing didn't work, still don't have any items, send me the db at lpaul@socal.rr.com (directed to the guy with the complete db) K, dont ask

Pneu · #6 12-10-2002, 04:41 AM

I'm going to hold on sending you the db for tonight, i'm not sure what's wrong but I do not seem to be able to add new spawns so I think my DB is missing a field of data, i'll work out whats wrong and send it to you then.

Pneu

Slayer02 · #7 12-10-2002, 06:15 AM

Ok cool

Pneu · #8 12-11-2002, 10:10 AM

Gave up trying to fix my db tonight and deleted it. I will start again fresh on Friday and see if I get it right this time, alas I think we both came to EqEmu at a bad moment because we seem to be using a multiple patched database from a previous release :/ Just a matter of working out which db to use and what patches in what order.... trial and error....

Unless anyone else is willing to post a working .sql or email it ?

EDIT: Oh look - the order to do things is above!

Working on it... Will send you when done (another late night inc)

Pneu
thane@globalnet.co.uk

Pneu · #9 12-11-2002, 11:09 AM

Fully spawned DB emailed to you, sorry the attachment is 3mb :/

Pneu

Slayer02 · #10 12-11-2002, 11:55 AM

Its ok, I got 10 gigs to fill up

DrEvil · #11 12-11-2002, 04:00 PM

pneu can u email that to me as well.

drevil@cfl.rr.com

fufet · #12 12-11-2002, 08:04 PM

could you either email this to me or upload it somewhere?

fufet@imperiumguild.com

Pneu · #13 12-12-2002, 07:37 AM

Given that a few are asking for this and undoubtedly more will I am posting it to an ftp location. This is a UK server and I have limited bandwidth but it is 24/7 and free

www.users.globalnet.co.uk/~thane/EqEmuSql.zip

I noticed tonight that the quests section isn't working as intended, however I understand the quest engine is about to be changed so I would not worry too much about that.

This file will be deleted from my ftp site upon the next EqEmu release.

Pneu[/url]

irageon · #14 12-19-2002, 11:54 PM

now when I download your zip file.. I can install 0.4.0 emu create eq db and use source yourdb.in.zip.file ?

I can run 0.31 emu and 0.4 emu too but I never can update main db with addons or world data.. whenever I try to update I get many errors in mysql :((
now I try install 0.4.0 ..run new installation of mysql
create database eq;
source yournameofsqldb;
and then I have items and monsters ?? and what about shopkeepers and with shop recipe ?

btw > can you upgrade default 0.4.0 db with worlddata 1.0 , then dump to 1 big file and upload it to web ?
worlddata is best database with spawns/items/monsters/shopkeepers.. please..

Pneu · #15 12-21-2002, 01:03 AM

Quote:

Originally Posted by irageon

now when I download your zip file.. I can install 0.4.0 emu create eq db and use source yourdb.in.zip.file ?

Yes, only extract the .sql from the .zip first.

Quote:

Originally Posted by irageon

now I try install 0.4.0 ..run new installation of mysql
create database eq;
source yournameofsqldb;
and then I have items and monsters ?? and what about shopkeepers and with shop recipe ?

It is not EqLive, but the addon db does have many shopkeepers etc. Whilst the addon db is not perfect it does to a pretty good job of being eq-like.

Quote:

Originally Posted by irageon

btw > can you upgrade default 0.4.0 db with worlddata 1.0 , then dump to 1 big file and upload it to web ?
worlddata is best database with spawns/items/monsters/shopkeepers.. please..

Personaly no, I do not have worlddata db. I am actually seeking a working blank db myself to begin afresh (but using: mysqldump -d eq > dbstruct.sql results in a database that crashes EQadmin :( ) so i'm sorry to say I wont be seeking to persue such a path.

Pneu