A small problem I guess.
Code:
mysql> source player_load.sql Yeah. Any idea on how to fix that? |
Double post because I am blind and can't seem to find the Edit button.
Code:
mysql> source load_player.sql |
I hate to post the obvious question, but, did you run the mysql command line from the folder where the load_player.sql script is located?
|
Code:
create database peq; |
Quote:
|
How about, instead of
Code:
\u peq Code:
use peq |
Quote:
|
It should be the same thing but maybe it's flaky? Did you try doing each line one at a time or all at once? You have the ; after the first line but not after the "\u peq" line. I know you can cut and paste many lines to run in sequence and without the ; after each line it will throw errors. Otherwise, maybe the database wasn't created correctly. Have you looked through the wiki?
http://www.eqemulator.net/wiki/wikka...kka=MySQLSetup |
One at a time. And I didn't put a ; after \u peq.
|
That error message indicates that mysql can't find the load_player.sql file.
http://dev.mysql.com/doc/refman/4.1/...ror-codes.html Find the folder where the load_player.sql file is located. I run my server in Linux and open a terminal window, then cd to the folder, and run mysql from there. Do you get an error message when you enter "use peq"? I gather that you don't and actually get a "database changed" message. So when you try to source that file mysql can't locate it. I think this is what you need to track down. Where did it go? I've never tried using a path before the filename inside of mysql, not sure if that will work or not. I try to keep my typing simple by changing to that folder first. |
Quote:
C:\peqdb\peq_db No I don't get an error when I enter "use peq", I get the Database Changed message. Even when I make a new DB w/ the name of the folder load_player.sql is in, it still gets the same error. |
Open a command prompt, and type:
Code:
cd C:\peqdb\peq_db Code:
dir |
Quote:
Now it happened again, same error, except w/ Peqdb_1129Rev223.sql file when I try to source. |
Same thing... Find the file and then start mysql. It is case sensitive, so make sure you are using the exact file name.
|
Thanks. The program was just being a tad stubborn >_>;.
Now it works. Thanks LeftRoad and trevius! |
All times are GMT -4. The time now is 07:10 PM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.