Terminal Reality Server DB relese

morpheus014 · #1 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

[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

Ariak · #2 07-12-2002, 07:20 AM

32000 items? wtf??

Ariak · #3 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 · #4 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 · #5 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 · #6 07-12-2002, 07:36 AM

and that didnt work....

morpheus014 · #7 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 · #8 07-12-2002, 07:41 AM

The format is mysqldump databasename > whatever.sql

morpheus014 · #9 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 · #10 07-12-2002, 07:50 AM

I was wondering why the size was so small.

LOL.

morpheus014 · #11 07-12-2002, 07:52 AM

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

morpheus014 · #12 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 · #13 07-12-2002, 07:56 AM

^^ my plea for help...

Ariak · #14 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 · #15 07-12-2002, 08:04 AM

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