unable to execute a script using .sql files

[kirty]

hello,

I'm trying to execute a sql script file using a file using command prompt on windows. But I'm always getting this error:
failed to open file script.sql error: 2
I put sql script is in the mysql directory but even if I put in it my database's it's the same error.

Anybody has an idea of why I'm getting this wrong ?

Thnx.

[a7004]

hello,

I'm trying to execute a sql script file using a file using command prompt on windows. But I'm always getting this error:
failed to open file script.sql error: 2
I put sql script is in the mysql directory but even if I put in it my database's it's the same error.

Anybody has an idea of why I'm getting this wrong ?

Thnx.

Hello,

don't use ";" at the end of the command line!

Try it!

Bye!

[kirty]

Hello,

don't use ";" at the end of the command line!

Try it!

Bye!


Thnx , but I didn't...and still not working :(

[Scott MacVicar]

in windows?

go to c:/mysql/bin presuming thats where you installed mysql
type

mysql -uUSERNAME -pPASSWORD DATABASENAME < c:/path/to/file.sql