Search Results

ERROR 2 (HY000) at line 1: File '\cygdrive\d\Load\.tmp_d_.csv' not found (Errcode: 2)

---------- Post updated at 05:00 AM ---------- Previous update was at 03:30 AM ----------

Problem gone.
I...

1../tmp_d_.csv
Work well in cygwin
Give Error in Window Task
ERROR 2 (HY000) at line 2: File '.\xxx.csv' not found (Errcode: 2)
Windows change / to \ in Error
2. /cygdrive/d/Load/tmp_d_.csv...

I tried it.
Error
ERROR 2 (HY000) at line 1: File 'C:\cygdrive\d\CasusLoad\tmp_d_.csv' not found (Errcode: 2)

\cygdrive\d\Load\tmp_d_.csv
It's a correct linux directory.
D:\Load
It's give me the same error.

Error :
ERROR 2 (HY000) at line 1: File '\cygdrive\d\Load\tmp_d_.csv' not found (Errcode: 2)

Code in script :

mysql -e "load data local infile '/cygdrive/d/Load/tmp_d_.csv' REPLACE into table...

What you think about it ?
zmienna="UPDATE datebase.table SET U_O_ID=NULL WHERE U_O_ID LIKE '"$w4"' AND N_U != '"$w1"'"
mysql -u admin2 -pPassword12345 -e $zmienna ;

I get answer :
...

I'm understend fStart Directory. It can be usefull. Why do you use fOutput ?

If I use full directory string "/cygdrive/d/.../.../tmp.csv", it doesn't work.

mysql -u admin .... << EOF
UPDATE datebase.table
SET U_O_ID=NULL
WHERE U_O_ID LIKE '$w4'
AND N_U != '$w1'
EOF
It made without error, but it didn't do anythink in SQL table.

You put first ". in mysql "
Where is the last one ?

Can you give me example ?

---------- Post updated at 06:43 AM ---------- Previous update was at 04:12 AM ----------

But w1 and w2 aren't a table items. They are like A and B.

I'm make task in Task Scheduled with parametres :

c:\cygwin\bin\bash.exe -l -c "/full/path/to/command/plus-command >> /full/path/to/a/logfile 2>&1"

Hello
I have a problem with use bash script in windows task.
If I use script by cygwin it's working well.
If I use it by Windows task I'm get error
Error :

ERROR 2 (HY000) at line 2: File...

Hello.
It's my first steps in creat bash skript.
This is my skript :

mysql -e "
UPDATE datebase.table
SET U_O_ID=NULL
WHERE U_O_ID LIKE '"$w4"'
AND N_U != '"$w1"'
" -u admin...