I've got the #2 error while doing the guide

[IK91]

Well, this sucks. :(

mysql> create database peq;
Query OK, 1 row affected (0,00 sec)

mysql> \u peq
Database changed

mysql> source load_player.sql
ERROR:
Failed to open file 'load_player.sql', error: 2

[wayneg]

judging by the error message you didn't change your directory, you missed this part after the following line:

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

[IK91]

But I did do that. And what is "Instance Configuration Wizard", that threw me off quite a bit.

[joligario]

Make sure you are in the directory where you extracted the load_player.sql file before you run mysql.

The instance configuration wizard helps you set up your username/password. Seeing as how you were already logged in, you don't have to worry about that part.

Just an FYI, you can add the database in the command line now that you have created one.

C:\peqdb\> mysql -u root -D peq -p

[Calypso73]

I'm having the same problem as IK91. And I can't seem to find the load_player.sql file in the database or any folder. I'm just seeing 4 files. I may just try to do all over again.
If that doesn't solve it i'll post back.

[joligario]

Who's database are you loading? In the PEQ database, it is there.