[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

[zaphod2003]

Originally Posted by 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

Try the following:

Code:

\. c:/scripts/test.sql;

the '\' character in SQL is a command character so mySQL thinks you're adding extra parameters to your command.

Error 2 simply means it can't find the file.