Fully Updated Database

[mikenune]

The 0.5.6 DB is Here!

Note: This DB does NOT work with EQEMu 0.5.7!

Although the previous version was plagued with problems, the current version (for EQEMu servers v0.5.6) should work without any issues. PLEASE NOTE THAT THIS DATABASE CAN TAKE A LONG TIME TO SOURCE. This version of the DB has more than a half a million records spread across fifty six tables! Please be patient!

Current version: http://www.raskii.net/eqemu/eqemu056.zip [6.49MB download]

Previous version(s):
0.5.5 DB: http://www.raskii.net/eqemu/eqemu055.sql.zip [4.25MB download] (do not use!)

README.TXT
These SQL dumps contain:
- Myra's db version DR5.3.2
- TCMyWorld's Alpha 1 and 2
- govtcheese's loottable and NPC db version 0.3
- the 03/15/2004 door update

Instructions:
1) Extract the SQL files into MySQL's bin folder (typically C:\mysql\bin).
2) Create the eq database.
A) From the command prompt type "\mysql\bin\mysql -b -s -f -u root -p <password>"
(where <password> is your password, if any).
B) Type "create eq;"
2) Dump the SQL files into your new database.
A) Type "use database eq"
B) Type "source sql1.sql;"
B) Type "source sql2.sql;"
B) Type "source sql3.sql;"
3) Create any necessary user accounts.
A) Type "INSERT INTO account (id, name, charname, packencrypt, sharedplat,
password, status, lsaccount_id, gmspeed, revoked) VALUES (1, 'eqemu', '',
'', 0, 'eqemu', 250, NULL, 0, 0);"
B) Repeat the above step as necessary. Just be sure to change the id, name,
password, and status fields for each user.
4) Enjoy!

Many thanks to the EQEMu devs for their tireless work in creating this most excelent
program. Also, I would like to thanks both Myra and govtcheese for their efforts in
fleshing out the db. Keep up the great work guys!

mikenune

[vetoeq]

That's nice work there. It'll surely help quite a few folks who are having issues getting a working DB.

[mikenune]

Well, as you've probably noticed, I didn't get the MySQL dump out last night. :(

I went ahead and rebuildt the database to include the newest versions of both Myra's and gotvcheese's dumps. And, although I have no DB errors when I try and start up EQEMu, I can't get my 0.5.6 server to actually let me login. Because of this, I have no way of verifying the DB and decided not to upload it yet. :evil:

As soon as I can get my server working, I'll post the dump! I promise! :D

[RexChaos]

Isn't Myra's db incompatible with the MW database?

[Gossamer]

You may want to add v0.3 of the npc_types.update.sql and loot_updates.sql. I noticed they were just released a day or so ago.
Cheers!

[laerg619]

For some reason, when I tried to source that huge file yesterday, I could not, due to some error about some of the packets being too large. (Sorry, I know that's not too descriptive, but that's all I can remember about it at the moment =/)
After the sourcing was done, when I logged in there were no spawned mobs, so apparently however it is set to source in the NPC info, there's too much data... at least, for my computer.

Any ideas on why that sort of thing may happen? Has anyone else had this kind of issue?

[mikenune]

Hey everyone.

Looks like this project of mine isn't going so well. :(

laerg619, that error is happening because, when I exported the SQL dump, I told it to use a delayed insert instead of multiple inserts.

What does this mean?

Simple.

Instead of inserting each row one at a time, MySQL tries to load the whole dang table into memory before inserting it all at once into the DB!

The error you're running into is simply the MySQL daemon complaining that it doesn't have enough RAM allocated to load the entire table in it's memory.

Although you CAN change the amound of memory allocated to MySQL, it's kinda a pain. Until I get the new DB out (should be in just an hour or so) I would suggest that you not use the current DB.

The 0.5.6 DB will have this problem fixed.

[Destavator]

I have sourced your DB yesterdays and found maybe some errors in it.

In almoust all Zones, theres a point where are a HUGE ammount of MoBs, maybe they are below world when zone starts up and they get portet to save spot, or something like that.

Guards dont help you if you are attacked and run towards them, they just stand there without doing anything.... maybe a error in the faction tables ?

[Gossamer]

I too have noticed many mobs 'bunched up' together in zones. I agree that its something to do with under the world mobs. Take Kael for instance. I see 2 mobs out of place and some others are the wrong size. When fixing the size of the other mobs, they either dont fit within the map where they are placed or something cause they bunch up with the others in the safe zone and do not appear where they are supposed to spawn. You can not hit the mobs with your weapon or cast on them when they are bunched up, but you can bash them which usually causes a train if you have the factions in place. Any suggestions on how to go about correcting this?

[IATwistedFourty]

just curious if i should start a new db i allready have MW055.sql both alpha1 and 2 sourced and now when i sourced the sql files that came with this i had alot of new files added but also got alot of errors would it be best just to use the sql files that i got off this post or use what i have right now

id test it out but i was stupid and patched without a backup eq so ill have to wait

thx for any input :D

[Gossamer]

5.7 world.exe crashes on character creation with this database. I had to go back to my 5.6 exes to make it work. Just FYI.

[mikenune]

I too have noticed many mobs 'bunched up' together in zones. I agree that its something to do with under the world mobs. Take Kael for instance. I see 2 mobs out of place and some others are the wrong size. When fixing the size of the other mobs, they either dont fit within the map where they are placed or something cause they bunch up with the others in the safe zone and do not appear where they are supposed to spawn. You can not hit the mobs with your weapon or cast on them when they are bunched up, but you can bash them which usually causes a train if you have the factions in place. Any suggestions on how to go about correcting this?
Yes, there are some problelms with MoBs bunching up in the same spot. Most of the time this occurs in dungeons which leads me to believe that you are correct in why this is happening. Although you will frequently find smaller bunches (just 2 or 3 MoBs) in outdoor zones.

In the dungeons, this is likely a problem with the coordinate system causing MoBs to all be "teleported to a safe spot" just like what happens to a PC when you pop outside the world.

With the outdoor groups (which usually don't cause any problems. It just makes it less of a hassle to chase things down :)), this is probably a problem with either the "MoB spawn logic" (the server thinks it's time to spawn a new MoB at that spot/grid even though the original one wasn't killed) or with the spawn timers/grid setups.

The only way to fix these problems would be to download the packet collector and help gather accurate spawn data. Or, if you're a programmer, you can take a look at the source code and see how the server manages spawns.

[mikenune]

5.7 world.exe crashes on character creation with this database. I had to go back to my 5.6 exes to make it work. Just FYI.
Good to know. They probably changed some of the tables in the db for 0.5.7.

[Gossamer]

OK The 64million dollar question. Do we want to have MYRA in with the TCMW database? I read in another thread they are not compatible, but I'm running it in a 5.6 environment with no visable issues as of yet. Perhaps this is why its not compatible with 5.7 tho? Thoughts?

EDIT
The MW database works with 5.7, didnt try just the MYRA tho.