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

[Calypso73]

I'm a little confused by the commands given on your screen. How do I start mysql from the directory where my .sql files are located? I mean, what command am I putting in. I type the command: cd\peqdb which then puts me to C:peqdb> After that I type in: mysql -u root -p and then last I put in:

create database peq;
\u peq
source load_player.sql

In which I get the Failed to open file 'load_player.sql', error: 2

[joligario]

Before you type in the "mysql - u root -p", type in "dir" and look if all those files are listed (aa_timers.sql, account.sql, load_player.sql, etc.).

[Xenezie]

Right, I looked over that, and is partly why I posted that other little bit.


He needs to find the directory the file is in then do a:

\. c:/YOURDIRECTORY/load_player.sql;

example: c:/programs/peqdb/load_player.sql then just add in the rest.

This will have the same effect as navigating your command line there.

[Calypso73]

This is what I get:


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Willard>cd\peqdb

C:\peqdb>dir
Volume in drive C has no label.
Volume Serial Number is 9026-53CA

Directory of C:\peqdb

09/26/2008 01:24 AM <DIR> .
09/26/2008 01:24 AM <DIR> ..
09/26/2008 01:24 AM 0 cd
09/25/2008 06:57 PM <DIR> peq_db
1 File(s) 0 bytes
3 Dir(s) 187,759,304,704 bytes free

C:\peqdb>


What command should I be typing in next

[Xenezie]

create database peq;

\u peq

source load_player.sql

Make sure you are pressing enter after each part.

[joligario]

There's your problem! You have the peq_db within your peqdb folder.

I type the command: cd\peqdb....

Here you should be typing in "cd\peqdb\peq_db". Then try it. Have fun, you are on your way to having a server!