Can't save mysql dump file to my hard drive from a java progam

Asked Feb 01 '22 at 21:06

Active Feb 01 '22 at 21:10

Viewed 19 times

I'm using the following command in a java program (other files are correctly copied to new folders):

String cmd = "c:\\wamp64\\bin\\mysql\\mysql5.7.36\\bin\\mysqldump -uroot -ppassword --databases test > c:\\mydumps\\test.sql;

Nothing is saved to mydumps folder with the following statement: Runtime.getRuntime().exec(cmd);

But if I run the cmd string at a command prompt, the test.sql file is saved to mydumps folder. I'm using Apache Netbeans 12.6 and Java 17.0.2 on Windows 10.

I'm not sure what I'm missing.

edited Feb 01 '22 at 21:10

Jim Garrison

85,615
20
155
190

asked Feb 01 '22 at 21:06

Ron

1

Redirection is a shell construct. `Runtime#exec()` does not invoke the shell. Use `ProcessBuilder` to set up the redirection yourself. – Jim Garrison Feb 01 '22 at 21:11
That's what I needed. If anyone else is inerested, this works: – Ron Feb 01 '22 at 22:01
ProcessBuilder builder = new ProcessBuilder(); – Ron Feb 01 '22 at 22:02
builder.command(("cmd.exe", "/c", cmd); builder.start(); – Ron Feb 01 '22 at 22:03

Can't save mysql dump file to my hard drive from a java progam

0 Answers0