PDA

View Full Version : Terminal Reality Server DB relese


morpheus014
07-12-2002, 06:58 AM
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
07-12-2002, 07:20 AM
32000 items? wtf??

Ariak
07-12-2002, 07:29 AM
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
07-12-2002, 07:31 AM
wtf? why isnt the raw item data showing up... let me check file to see if its skrewed

morpheus014
07-12-2002, 07:31 AM
argh stupid thing may have skrewed up during upload or something its corrupted, ill reupload the db file

morpheus014
07-12-2002, 07:36 AM
and that didnt work....

morpheus014
07-12-2002, 07:38 AM
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
07-12-2002, 07:41 AM
The format is mysqldump databasename > whatever.sql

morpheus014
07-12-2002, 07:44 AM
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
07-12-2002, 07:50 AM
I was wondering why the size was so small.

LOL.

morpheus014
07-12-2002, 07:52 AM
Heh it should be around 14 1/2 MB or so...

morpheus014
07-12-2002, 07:55 AM
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
07-12-2002, 07:56 AM
^^ my plea for help...

Ariak
07-12-2002, 07:59 AM
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
07-12-2002, 08:04 AM
thanks a ton DB will dump now finally.. xp is testy about stuff some times

morpheus014
07-12-2002, 08:06 AM
K will reupload DB with the right db.sql file now =) hopefully all will work this time =P

morpheus014
07-12-2002, 08:11 AM
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
07-12-2002, 08:18 AM
:)

morpheus014
07-15-2002, 03:43 AM
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
07-17-2002, 04:54 AM
I still have that game around here somewhere....