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-25-2008, 04:32 AM
Calypso73
Fire Beetle
 
Join Date: Mar 2006
Posts: 11
Default

I don't know. I pretty much went right by what the info told on the server creation page. It just doesn't seem to be locating the load_player.sql file, although it's right there. Isn't there any way of extracting that without using the mysql command line? Otherwise I'm just going to try at a later time. Thx for the help though.
Reply With Quote
  #2  
Old 09-25-2008, 04:34 AM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,498
Default

You can do it manually or copy/paste.

Copy the block of code, right click the cmd window and select paste or you can manually type each line in... More prone to typos though.
Reply With Quote
  #3  
Old 09-25-2008, 11:19 PM
Calypso73
Fire Beetle
 
Join Date: Mar 2006
Posts: 11
Default

Well I give up. I've tried numerous times to set this up and always get stuck at the source load_player.sql . it just gives me "Failed to open file 'load_player.sql', error: 2"

I've also tried copying/pasting files to the command prompt window and get the same error. I remember setting up a server awhile back(2 yrs ago) and didn't have this trouble. Oh well, thx for the help though. I'll keep searching for some answers on the forum or other site
Reply With Quote
  #4  
Old 09-25-2008, 11:36 PM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,498
Default

Ensure all the tables are in the same folder as your load_player.sql and make sure your load_player.sql looks like this:

Code:
source aa_timers.sql;
source Banned_IPs.sql;
source account.sql;
source botinventory.sql;
source botleader.sql;
source botsowners.sql;
source character_.sql;
source character_backup.sql;
source commands.sql;
source eventlog.sql;
source faction_values.sql;
source group_id.sql;
source group_leaders.sql;
source guild_members.sql;
source guild_ranks.sql;
source guild_relations.sql;
source guilds.sql;
source hackers.sql;
source inventory.sql;
source launcher.sql;
source launcher_zones.sql;
source name_filter.sql;
source object_contents.sql;
source petitions.sql;
source player_corpses.sql;
source player_corpses_backup.sql;
source quest_globals.sql;
source rule_sets.sql;
source rule_values.sql;
source sharedbank.sql;
source timers.sql;
source variables.sql;
source zone_flags.sql;
Reply With Quote
  #5  
Old 09-25-2008, 11:59 PM
Calypso73
Fire Beetle
 
Join Date: Mar 2006
Posts: 11
Default

Yes it looks exactly like that, but when I paste it to the command prompt window, it just gives all files the failed to load error:2
Reply With Quote
  #6  
Old 09-26-2008, 02:14 AM
Xenezie
Fire Beetle
 
Join Date: Oct 2005
Location: Spanaway, Washington
Posts: 19
Default

It looks to me that you've forgot to end your command with a ;

Try

Code:
source load_player.sql;
or

Code:
\. c:/YOURDIRECTORY/load_player.sql;
Reply With Quote
  #7  
Old 09-26-2008, 03:02 AM
joligario's Avatar
joligario
Developer
 
Join Date: Mar 2003
Posts: 1,498
Default

But if he didn't end with a semi-colon, it wouldn't give him error 2 file not found. It would give him the ->.

Are you starting mysql from the directory where these .sql files are located?

start -> run -> cmd
Code:
C:\Documents and Settings\Your Name>cd \peq
C:\peq>cd peq_db
C:\peq\peq_db>dir
 Volume in drive C has no label.
 Volume Serial Number is ****-****

 Directory of C:\peq\peq_db

09/21/2008  08:22 AM    <DIR>          .
09/21/2008  08:22 AM    <DIR>          ..
02/12/2008  10:17 AM             1,861 aa_timers.sql
02/12/2008  10:17 AM             2,272 account.sql
04/21/2008  03:07 PM               387 Banned_IPs.sql
02/12/2008  10:17 AM             1,755 botinventory.sql
02/12/2008  10:17 AM             1,722 botleader.sql
02/12/2008  10:17 AM             1,763 botsowners.sql
03/29/2008  03:17 PM                98 bot_npcs.bat
03/16/2008  04:40 PM                98 bot_npcs.sh
02/12/2008  10:17 AM             2,363 character_.sql
02/12/2008  10:17 AM             2,372 character_backup.sql
04/21/2008  03:07 PM            23,992 commands.sql
09/14/2008  10:34 AM    <DIR>          CVS
09/06/2008  02:26 PM             1,250 drop_player.sql
09/06/2008  02:26 PM             1,780 drop_system.sql
02/12/2008  10:17 AM             2,078 eventlog.sql
02/12/2008  10:17 AM             1,835 faction_values.sql
.....
.....
etc, etc, etc.

C:\peq\peq_db>mysql -u root -p
Enter password: ****

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.51a Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>source load_player.sql;
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 08:15 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