problem with source db.sql

[MuddzVon]

I am at the part in the EQEmu server set-up where when you start mysql.exe and type use eq; that works fine, but when I type source db.sql; i get an error saying unable to open source ERROR 2 or something along those lines....any help would be appricated thanks

~M

EDIT: sorry...just want to add that I have copied db.sql to my C:\mysql\bin directory...

[MuddzVon]

o i guess my post is confusing...I'm still having the problem EVEN tho I have copied the db.sql file to the bin directory...any suggestions? I'm tryin to do minilogin i wish to play by myself

~M

[Nira]

Direct from the readme

[quote]4. Now from "Winmysqladmin.exe" select the Database tab and right click the area for Databases and click Create Database.
Type in "eq" as the database name (without the quotes) and click Create database.

NOTE: You may close Winmysqladmin.exe now or you can hide it
Though some users may be required to leave this running to work.

5. Run "mysql.exe" from C:\mysql\bin directory
Type in "use eq" without quote, and press Enter
Type in "source db.sql" without quotes, and press Enter
A bunch of lines should pass by (that is normal).
If you get an error at this point then you didn

[MuddzVon]

...yes i did read my inital post...I type use eq; and it works fine...i get the error when i type source db.sql; afterwards

~M

[Trumpcard]

Do you actually cd to the mysql/bin directory first and THEN type mysql?

[Nira]

...yes i did read my inital post...I type use eq;
Oops, my bad. :D

Could you type out the error you are getting, I have no ideas how to give you a quick fix. Also, what version is this from?

[MuddzVon]

here is the error im getting

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.54-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use eq;
Database changed
mysql> source db.sql;
ERROR:
Failed to open file 'db.sql', error: 2
mysql>[/quote]

[Trumpcard]

Well, it's obvious it's not finding the db.sql file.


Show the dos commands you are typing to start mysql....

And give a 'dir' listing of the directory you are running mysql from..

[MuddzVon]

im sorry what do you mean by showing dos you are tying to start mysql...kinda new to all this...I have a good understanding of a few things and DOS is over my head a lil :?

[MuddzVon]

ok.......nm that im an idiot ok....I have db.sql in my C:\mysql\bin directory and mysql.exe is in that directory also