Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2008, 01:27 AM
Zandig's Avatar
Zandig
Hill Giant
 
Join Date: Jun 2006
Location: New York City
Posts: 180
Default

Quote:
Originally Posted by Annihilator View Post
What kind of computer are you using that let you source 120MB of data in 10 minutes?!?!? The PC that I have dedicated to the Emu server isn't a speed demon by far but it's no snail. Old method only took me 2 minutes 40 seconds to do a complete source of the DB.

The biggest drawback is that the new method processes line by line rather than a complete table at at time.

I will try 1091a later and see how long it takes for me to source.
AMD FX-60
2 gigs ram
WinXP

...good to see 1091a is sourcing better.
Reply With Quote
  #2  
Old 02-15-2008, 01:39 AM
Annihilator
Sarnak
 
Join Date: May 2007
Posts: 47
Default

Yep. Source time back down to a 2.5 minutes on a P4 3GHz with a gig of memory. Much improved.
Reply With Quote
  #3  
Old 02-21-2008, 08:34 AM
Bishop4351
Sarnak
 
Join Date: Sep 2006
Location: Texas
Posts: 49
Default

Not sure in windows but you can just for loop it to import the db's in linux with some thing simple like:

for file in *.*; do mysql peq < $file; done

This would also mean that every file in the folder was one you wanted in the db.
Reply With Quote
  #4  
Old 02-25-2008, 03:01 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

I recommend everybody grab the newest commands.sql from CVS. In contains ALL EQEmu commands, their default access values, and a handy new description field with their descriptions.
Reply With Quote
  #5  
Old 02-25-2008, 07:24 AM
leslamarch
Discordant
 
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
Default

CD,
I was just wondering if you could point me in the right direction for a change log for the database? Sorry if i missed it somewhere
Thanks
~LL~
Reply With Quote
  #6  
Old 02-25-2008, 08:01 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

http://www.projecteq.net/phpBB2/view...c53dbc5bf86a99

Is as good as we'll get. It's a good overview of the changes, but if every change was documented, half of my time would be spent writing that up
Reply With Quote
  #7  
Old 02-25-2008, 08:17 AM
leslamarch
Discordant
 
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
Default

Quote:
Originally Posted by cavedude View Post
http://www.projecteq.net/phpBB2/view...c53dbc5bf86a99

Is as good as we'll get. It's a good overview of the changes, but if every change was documented, half of my time would be spent writing that up
Perfect, Just what i was wanting to see.
Thanks So Much
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:23 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3