Windows shell script

[rafamagalhaes]

Friends,

I have a script .bat with the command:

c:\xamp\mysql\bin\mysql.exe -u root < c:\scripts\medicao_contratos.sql

When I execute it, return:

C:\scripts>cxamp\mysql\bin\mysql.exe -u root 0<medicao_contratos.sql
The system cannot find the path specified.

What's happen?

Thanks!

 

[postmark]

Are you sure you have the c:\scripts\medicao_contratos.sql and it exists? Also, try --user instead of -u?

One more thing to try is to put the c:\scripts\medicao_contratos.sql in quotes like this: "c:\scripts\medicao_contratos.sql"

 

[rafamagalhaes]

I changed the command like your information, but the error continued.

C:\scripts>mysql --user root 0<"c:\scripts\medicao_contratos.sql"
'mysql' is not recognized as an internal or external command,
operable program or batch file.

Luke the "0" before "<"...

In the original command it not exists

mysql --user root < "c:\scripts\medicao_contratos.sql"

 

[sourceninja]

Sounds like the mysql executable is not in your path.

 

[Markbnj]

That path doesn't look right to me. In the first example you have c:\xamp, and in the second you have cxamp. Perhaps you simply copied it wrong.

In any case, the message means what it means. The path to the executable doesn't exist. It is either misspelled or you just have the name wrong. Try copying the path out of the script (without mysql.exe) and placing it after a 'cd' command, i.e. cd c:\xamp\mysql\bin. If that doesn't work then the path itself doesn't exist on that drive. If it does work then the mysql.exe file doesn't exist in the specified location.