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

[Calypso73]

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

[Xenezie]

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

Try

source load_player.sql;

or

\. c:/YOURDIRECTORY/load_player.sql;

[joligario]

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

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;

[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!