source load_player NOT working

[wicapirate]

First it seems I dont know how to PM Techguy84

I am going by Techguy84 Windows Server Setup Guide
I am to this point.

Project EQ

First thing is that you will need to obtain the lastest version of PEQ. Since it is constantly update, I can not give you a version number, but you will always get the newest when you download it, because you will be using WinCVS that you installed at the beginning.

To download

Open up WinCVS, close the Tip box and then click OK to the error about not having Python.
Now click on remote at the top and then click Check Out Module. Then enter the following information

Module name and Path on Server : peq_db
Local Folder to Check Out To : C:\peqdb
CVSROOT: (make sure this is checked) :pserver:anonymous@peq.cvs.sourceforge.net:/cvsroot/peq

Now click OK to start the download. You should see several green texted items scrolling through the window. This will take a few minutes to complete so make sure you wait till it says Done. If at anytime it stops and give you a connection error, just repeat the check out module, all the information is still there so all you have to do is click OK again and retry it.

Once this is done, you will need to download the quest the same way.

Module Name and Path on Server : peq_quests
Local folder to Check out to : C:\peq_quest
CVSROOT :pserver:anonymous@eqemuquests.cvs.sourceforge.net :/cvsroot/eqemuquests


Now that you have both things downloaded, lets go ahead and source in your database to MySQL.

Sourcing in the Database

((( IF AT ANY TIME YOU RECEIVE A ERROR WITH THESE STEPS, BE SURE TO CHECK YOUR SYNTAX )))
((( IF THE ERROR IS STILL THERE, AND YOUR TYPING THINGS IN RIGHT, SEARCH )))
((( THE FORUMS FOR A SOLUTIONS, OR PM ME AND I WILL TRY TO HELP )))


Click Start->Run-> and type in cmd to bring up your command prompt
Now type in cd\peqdb
You should be at C:\peqdb>

Now type in
mysql -u root -p
and type in your password (from the Instance Configuration Wizard)

You will now see something like this,
Welcome to MySQL monitor. Commands end with ; or \g
Your MySQL connection ID is 2
Server Version: 5.0.37-community-nt MySQL Community Edition <GPL>
Type help; or \h for help. Type \c to clear the buffer.
mysql>

If that is correct, you now need to type in the following commands, pressing enter after each line.
Note: changed in accordance with [http://eqemulator.net/forums/showthread.php?t=23536∞]
create database peq;
\u peq
source load_player.sql
(wait until this is done. 1~5 min)

When I type in the last line;
source load_player.sql
I get
ERROR:
Failed to open file 'load_player.sql', error 2

I have also tried

source drop_player.sql
I get
ERROR:
Failed to open file 'drop_player.sql', error 2

[FallenOne]

I have had that error before and it should be simple to fix, seems that when you downloaded from the cvs you put in c:/peq_db as your source to download into, when you do this it actually puts the files in c:/peq_db/peq_db. so you should be able to just browse to that additional folder then do your sourcing, however if this is not your problem then i am sorry without more information I will be unable to assist. I hope that is your problem tho heh simple to fix

[wicapirate]

So how do I retrieve it from there ?

[Lord_Vindus]

Originally Posted by wicapirate

So how do I retrieve it from there ?

You currently have the DB being saved under C:\peqdb. However, when it saves all of the information, it will be in a folder. So you are set to the incorrect directory.

Try:

cd C:\peqdb\peq_db
source load_player.sql