Ich will "mysqldump.exe" starten. Dieses Programm ist bei Mysql Server bei.
Ich will damit meine Datenbanken sichern.
RunProgram will nur die Parameter nicht übergeben.
Wenn ich es so versuche:
Code: Alles auswählen
Compiler = RunProgram("D:\server\xampp\mysql\bin\mysqldump.exe", "--opt -u root --all-databases > dbdata.sql","", #PB_Program_Open|#PB_Program_Read)
Output$ = ""
If Compiler
While ProgramRunning(Compiler)
Output$ + ReadProgramString(Compiler) + Chr(13)
Wend
Output$ + Chr(13) + Chr(13)
Output$ + "Exitcode: " + Str(ProgramExitCode(Compiler))
EndIf
MessageRequester("Output", Output$)
Versuch ich es so:Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help
Exitcode: 1
Code: Alles auswählen
Compiler = RunProgram("D:\server\xampp\mysql\bin\mysqldump.exe",chr(34)+ "--opt -u root --all-databases > dbdata.sql"+chr(34),"", #PB_Program_Open|#PB_Program_Read)
Output$ = ""
If Compiler
While ProgramRunning(Compiler)
Output$ + ReadProgramString(Compiler) + Chr(13)
Wend
Output$ + Chr(13) + Chr(13)
Output$ + "Exitcode: " + Str(ProgramExitCode(Compiler))
EndIf
MessageRequester("Output", Output$)
Code: Alles auswählen
Compiler = RunProgram(chr(34)+"D:\server\xampp\mysql\bin\mysqldump.exe"+chr(34), "--opt -u root --all-databases > dbdata.sql","", #PB_Program_Open|#PB_Program_Read)
Output$ = ""
If Compiler
While ProgramRunning(Compiler)
Output$ + ReadProgramString(Compiler) + Chr(13)
Wend
Output$ + Chr(13) + Chr(13)
Output$ + "Exitcode: " + Str(ProgramExitCode(Compiler))
EndIf
MessageRequester("Output", Output$)
Gebe ich es in der Eingabeaufforderung von Windows ein:
Code: Alles auswählen
D:\server\xampp\mysql\bin\mysqldump.exe --opt -u root --all-databases > dbdata.sql