Request:Fully Compiled DB.

[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_do...pha2_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.p...mp;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 -)