Why this shellexecute() not work?

[ShumingWang]

Hi,
This not works,only shows a few top lines of the backup file d:\mysqldata.sql :
shellexecute(odlg:hwnd,,"mysqldump.exe","--opt --host 192.168.0.123 --port=3306 -u root -p -C mysqldata>d:\mysqldata.sql",,.t.)


While this works:

fp:=FCREATE("bak.bat")
FWRITE(fp,"@ECHO OFF")
FWRITE(fp,CRLF+"mysqldump.exe --opt --host 192.168.0.123 --port=3306 -u root -p -C mysqldata>d:\mysqldata.sql")
FCLOSE(fp)
WaitRun("bak.bat")
FERASE("bak.bat")

Regards!
Shuming Wang

[Enrico Maria Giordano]

Try

Code: Select all

shellexecute(odlg:hwnd,0,"mysqldump.exe","--opt --host 192.168.0.123 --port=3306 -u root -p -C mysqldata>d:\mysqldata.sql",0,1)

EMG

[ShumingWang]

EMG,
Still as before, not work.

Shuming Wang

[Enrico Maria Giordano]

Try without the redirection.

EMG

[ShumingWang]

EMG,
How?
Thanks!
Shuming Wang

[Enrico Maria Giordano]

Code: Select all

shellexecute(odlg:hwnd,0,"mysqldump.exe","--opt --host 192.168.0.123 --port=3306 -u root -p -C mysqldata",0,1)

EMG

[ShumingWang]

EMG,
mysqldata>d:\mysqldata.sql
This means from mysqldatabase 'mysqldata' backup to local file d:\mysqldata.sql . can't be cuted to 'mysqldata '.

Shuming Wang

[Enrico Maria Giordano]

Then try

Code: Select all

shellexecute(odlg:hwnd,0,"mysqldump.exe",'"--opt --host 192.168.0.123 --port=3306 -u root -p -C mysqldata>d:\mysqldata.sql"',0,1)

EMG

[ShumingWang]

EMG,
Not work still.
Is because of the para too long ?
Shuming Wang

[Enrico Maria Giordano]

I don't know, sorry.

EMG