Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2013, 12:24 PM
NEEDADISPENSERHERE
Fire Beetle
 
Join Date: Nov 2009
Posts: 12
Default

Thanks for the answer Provocating. I was missing tons and tons of .sql files (zone.sql etc) and knew it was because I sourced wrong and was hoping for an answer akin to the walkthrough ie. step by step, detailed instruction on what files to source in what order etc.

However, I figured it out. For anyone wondering, you no longer source anything in the old database whatsoever. Download the peqbeta (or whatever the database file will be named in the future, it'll contain .sqls) and the quests. Place the quests where the guide tells you to and extract all of the .sqls in the database archive in your C:\EQ\SQL folder. Open up MySQL command prompt as the guide tells you to (make sure you're in the SQL folder) and type 'source user_tables_XXXX;' (without quotes) where 'XXXX' is the date and then type 'source peqbeta_XXXX;' (or whatever the file will be named in the future, will be the biggest file from the archive you extracted from) and then type exit once it's done. *ONLY* source user_tables if it's a fresh install, continue to source more recent database updates as they release per normal though (just don't ever source user_tables again).

Also, if anyone screwed up sourcing like I did, you're going to need to point command prompt to your SQL folder, open up mysql prompt and type 'drop database peq;' and then create a new database as the guide directs (just ignore their database links and what to source, it's out of date).

Sorry for wasting your time provocating but thanks anyways man! Hope everyone will excuse the spam as well.
Reply With Quote
  #2  
Old 09-16-2013, 12:26 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

You mights still want to monitor those log files, I found I was still missing a table and a few updates. You will clearly see a SQL error in the logs.
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 07:39 AM.


 

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