Search results for query: *

This works: MyBatchFile.BAT mysqldump -%1 -%2 %3 > %4 and: ShellExecute(0, "open", "c:\MyBatchFile.BAT", "umyid, pmypass, admData, c:\backup1.txt", "", 0) These don't work: ShellExecute(0, "open", "mysqldump", "-umyid -pmypass admData > c:\backup1.txt", "", 0) ShellExecute(0, "open"...

how to create a text file from VFP? I want to create a text file with filename: mybackup.txt with the content: mysqldump -%1 -%2 %3 > %4 Thanks for the help.

I have tried with batch file, it works perfectly, thank you so much. if I call directly with ShellExecute(), it doesn't work, it has to be with batch file.

Thanks for the suggestion. only I don't want the client to know the database's user id and password.

I want to hide the DOS command box, for the command: RUN mysqldump -umyid -pmypass admdata > c:\backup1.txt I was suggested to use ShellExecute. How can I do that? I'm using VFP 9. Thanks for the help

Thanks for the input. I have a form with plenty of options, the clients can choose certain date, certain files, etc. it's easy to manage within the form and then execute the backup.

I want to run the backup using mysqldump.exe I'm using VFP 9 with MySQL database. I tried: RUN mysqldump -umyid -pmypass admdata > c:\backup1.txt RUN /n mysqldump -umyid -pmypass admdata > c:\backup2.txt RUN mysqldump -umyid -pmypass admdata > c:\backup3.txt /n the first one (without /n)...

I'm using RUN command inside the VFP, it will pop-up a DOS command box. how can I make it silent? thanks for the help