Terminal Reality Server DB relese

[morpheus014]

Follow the Below link to download the database seen on the Terminal Reality server, includes MSH upgrade, and 32000+ items, uses dwarde's and ariak's data for "uber" zones, ST, ToV, etc spawned out. Plz PM or email me with comments/questions
Yes it is v0.3.4 compatable.

Download TR db v3.4 (http://www.angelfire.com/d20/eqemu/db.html)

[EDIT]: DB is properly dumped now and should work properly, just incase u dont read next page =P plz post/ PM comments/problems to me, i appreciate the feedback

[EDIT2]: another blunder by me =) forgot eqmessages table, download the file from the below link

EQ Messages Table (http://www.angelfire.com/d20/eqemu/db.html)

[Ariak]

32000 items? wtf??

[Ariak]

Error in dump?

INSERT INTO items VALUES("1001","Cloth Cap");
INSERT INTO items VALUES("1002","Cloth Veil");

That is ALL there is for the items.

[morpheus014]

wtf? why isnt the raw item data showing up... let me check file to see if its skrewed

[morpheus014]

argh stupid thing may have skrewed up during upload or something its corrupted, ill reupload the db file

[morpheus014]

and that didnt work....

[morpheus014]

Ok think i found the problem. I use mySql front to dump the Db, since when i try to run mysqldump.exe on win XP it just closes and i get nothing... mysql front may have removed the actual item data from the dump. If i could get mysqldump.exe to work it should dump properly..

[TheClaus]

The format is mysqldump databasename > whatever.sql

[morpheus014]

ok do i run mysqldump.exe or do i run mysql.exe and use that command b/c wehn i use mysql.exe i get the following

mysql> mysqldump eq34 > eqdb34.sql
->

[Ariak]

I was wondering why the size was so small.

LOL.

[morpheus014]

Heh it should be around 14 1/2 MB or so...

[morpheus014]

some body heeeeeeeeeeeeeeeeeellllllllllllllpppppppppppp







.....this is really annoying i try to relese my DB but the entire thing gets skrewed up because of my homo mysqlfront!! the stupid dump window closes every time i open it im going crazy =P

[morpheus014]

^^ my plea for help...

[Ariak]

Start > run
type cmd

enter

cd ..
cd ..
cd..
Do until you're in C:\

cd mysql
cd bin
mysqldump eq > db.sql

db.sql will be the dumped database.

[morpheus014]

thanks a ton DB will dump now finally.. xp is testy about stuff some times

[morpheus014]

K will reupload DB with the right db.sql file now =) hopefully all will work this time =P

[morpheus014]

Thanks to Ariaks help I got all this figured out so the DB *should* work properly, just reuploaded it to the link on first post

[Ariak]

:)

[morpheus014]

Come on people lurkers DB has like 800 views lol and this may have more stuff than his (not sure so dont hold me to that comment).......................

[Kolo]

I still have that game around here somewhere....