[Clark_Kent]

Hi Everyone,

I'm having trouble trying to execute an sql script from the MySQL console. Let's say i have the test.sql script in the following location "C:\scripts\"

So in order to execute the test.sql script in that folder i would type...

Code:

mysql> source C:\scripts\test.sql;

or

mysql> \. C:\scripts\test.sql;

Both should do the same thing. I keep getting an error that states: "Failed to open file 'C:\scripts\test.sql;', error: 2"

The sql in the file is correct, i executed the script manually by typing out the sql into the console and it executes successfully, but when i try executing it via a .sql script i get that error.

Any idea what's wrong?

Thanks for your time,

- CK