Trouble Sourcing in Database

[zkrazz]

From the server setup guide, when I type in this part:

create database peq;
\u peq
source load_player.sql

the first two commands work but "source load_player.sql" creates an error and says it was not created. Also, which build version should I be putting for the next command? source peqdb_1118.sql? Cuz that doesn't work either. Any help with this would be great.

Thanks!

[So_1337]

Do you have the .sql files in the same directory that you're running mysql from?

Mind you mine's a Windows server, but when I first start a command prompt I'm at C:\Documents and Settings\User, etc. I have to change directory to my desktop (where I usually drop the .sql files in advance) before I start mysql (with mysql -u root -p).

If you don't have them in the directory you're running it from, then it may not be able to find them. As for what version of the database to use, that's up to you. If you're grabbing from CVS, there's a more recent version than 1118. (I believe it's up to 1118 B or C now).

[zkrazz]

I'll try that and see if it works. Thanks.

[Forlap_Thorninfoot]

I'm getting this error too now =/ i dont know what to do. i've checked to make sure everything is were it is supposed to be. i've checked that i was typing it right. I have no clue what i'm doing here, and am VERY lost. anyone have some help for me?

[Forlap_Thorninfoot]

problem solved. Let me put details here.

Ok, so i was getting an error that it couln't load it. For future people, when it unpacks it, make sure that it unpacks the files into the "peqdb" folder and not into the "peq_db"