Skip to content

Instantly share code, notes, and snippets.

@gevorg
Created May 26, 2015 19:23
Show Gist options
  • Save gevorg/955f33a9e5a3a9f90e0e to your computer and use it in GitHub Desktop.
Save gevorg/955f33a9e5a3a9f90e0e to your computer and use it in GitHub Desktop.
MySQL dumping and restoring in java
File backupFile = new File("C:/Users/gevorg/backup.sql");
String[] command = new String[]{"mysqldump ", "-uroot", "-proot", "test"};
ProcessBuilder processBuilder = new ProcessBuilder(Arrays.asList(command));
processBuilder.redirectError(Redirect.INHERIT);
processBuilder.redirectOutput(Redirect.to(backupFile));
Process process = processBuilder.start();
process.waitFor();
command = new String[]{"mysql ", "-uroot", "-proot", "test_new"};
processBuilder = new ProcessBuilder(Arrays.asList(command));
processBuilder.redirectError(Redirect.INHERIT);
processBuilder.redirectInput(Redirect.from(backupFile));
process = processBuilder.start();
process.waitFor();
@soheilrahsaz
Copy link

it doesn't work for me.
process.waitFor() never finishes and nothing is written to the backup file.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment