Request:Fully Compiled DB.

[Loosenut]

Ok, seeing that some are able to actually update their DB with the most recent files available and alot of others could not, I wanted to request that if someone who can compile the fully updated DB(alpha1,alpha2,doorsupdate,dbs.sql,etc.) and release it so that it can solve all the duplicate errors and other errors while trying to Souce these files.So if anyone who is able to do this, Would truly appreciate your service.

Thanks.

[RexChaos]

You give me hosting space and I'll be glad to pull one out for you. :)

[govtcheeze]

It isnt that it doesnt work, it just takes a LONG time in DOS due to the beep-on-error. Took me 16 hours yesterday, but it finally finished. I would use mysql-front as Jezebell suggested to make it go much quicker...when I sourced it into my linux machine, it took only a couple of hours.

I was actually going to post the sourced table, but the compressed file is 4M and this would drag on DSL upload speed.

edit: if you source db.sql first, you will have empty door, npc, and item tables (even tho it still takes a long time) due to table definitions differences...but following the newest instructions from jezebell should give good results.

[Loosenut]

Thanks anyway.

[wraithmajere]

The Result Of Doing This: (85% Fully Spawned DB W/ Recent Items and Loot Drops For 85% Of All Mobs)

Files You Will Need: (extract all of these to your c:\mysql\bin directory)

MW055-Alpha1-DB -
http://mwnpcmovdb.myftp.org/MW055_alpha1.zip

MW055-Alpha2-DB -
http://mwnpcmovdb.myftp.org/MW055_alpha_02.zip

Loot Updates -
http://home.gravyisgood.com/eqemu_download/v0.2_govtcheeze_mw_055_alpha2_addon.rar

Items Database -
http://emu.fliphost.net/files/itemdb.zip

Doors Update -- (RIGHT CLICK AND SAVE TARGET AS DOORSUPDATE.SQL)
http://cvs.sourceforge.net/viewcvs.py/*checkout*/eqemu/eqemu/eqemu/EQEMu%20Release/doorupdate-03-15-04.sql?content-type=text%2Fplain&rev=1.1.1.1

Once all of the files are extracted and or copied to C:\MYSQL\BIN

(This Step Is Only Needed If You Don't Already Have MYSQL Admin Access)

1. Start>Run>Cmd

cd\mysql\bin
mysql -u root mysql
grant all privileges on *.* to username@localhost identified by 'password' with grant option;
quit

(Change "username" and "password" to what you used when you first installed mysql/winmysql) - (You can also change "localhost" to something like 192.168.1.101 or something similar if your using a linksys router you can use your internal network ip as well)

2. Start>Run>Cmd

mysql
create database eq;
quit

mysql -f eq<mw055_alpha1.sql (wait for it to finish)

mysql -f eq<mw055_alpha_02.sql (wait some more - will see errors but it will fly by fast without beeps and takes hours less time)

mysql -f eq<doorsupdate.sql

mysql
use eq;
delete from items;
quit

mysql -f eq<dumpeditems.sql;

mysql
use eq;
delete from loottable;
delete from loottable_entries;
delete from lootdrop;
delete from lootdrop_entries;
quit

mysql -f eq<v0.2 - loot_update.sql (wait for it to finish)

[warning this next step takes a ton of time, no matter what you do, so do it before u go to bed lol] (Doing This Update Took 4hrs On My Intel 850mhz Gateway Laptop - Estimated)

mysql -f eq<v0.2 - npc_types_update.sql (takes forever but worth it)

All done.... if u dont ever want to do this again.... do this...

mysqldump eq>mybackup.sql

then if u ever mess your db up.... do this...

mysql
drop database eq;
create database eq;
quit

mysql -f eq<mybackup.sql

All Done... Hope This Helps Some Of You -)

[m0oni9]

"mysql --help" says that using the -b switch will turn off beep on error.

[Loosenut]

Need some help

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Owner>cd\mysql\bin

C:\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 3.23.58-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database eq;
ERROR 1044: Access denied for user: '@localhost' to database 'eq'
mysql>

[vetoeq]

Wraith,

I think that was very helpful for many out there. If you had time to link the .sql sources I'd suggest that you post be stickied as it seems to cover about 50% of the posts here in World Builders.

One question I have, weren't/aren't there DB's with most of the zone populated with mobs? It almost seems that the DB situation, as far as populated zones, has taken a couple of steps backwards in the last 3-6 months.

I seem to remember that TCS and someone else joined forces and were going to merge their DB's and that was going to be GREAT news...but nothing seems to have come of it. Also I seem to remember that someone was grabbing spawns from SEQ and nothing seems to have come of that either. Finally, I think Myra has most of the zones populated but not compat with 5.5.

I realize it's a ton of work and I'm continually grateful for those of you doing the world building, but I'd still love to see the world builders get together and create a DB to end all DB's.


-Veto

[Loosenut]

Im going to try out MySql-front. Thanks for tips and suggestions tho. Appreciate you taking your time out to do it.

oh and i <3 this:

I realize it's a ton of work and I'm continually grateful for those of you doing the world building, but I'd still love to see the world builders get together and create a DB to end all DB's.
:P

[mikenune]

loosenut, when you run mysql, you need to give it a username and password like this:
mysql -u root
If you don't add the "-u root" part, you get logged in as "nobody" and don't have permission to do anything.

If you're not familiar with database programs and SQL then I would suggest you use a program like Front-MySQL or (if you happen to have a Web Server handy on your local box :)) phpmyadmin.

[wraithmajere]

Okies updated the quick howto w/ links and removed some typos -) feel free to sticky it, or move it to the howto section hehe.

[xeeman]

Hi all,

I'm new here but am the webmaster and do the Self Installers for the MySEQ project.

If you need webspace to host any files, let me know and I'll provide it.