Created
May 26, 2015 19:23
-
-
Save gevorg/955f33a9e5a3a9f90e0e to your computer and use it in GitHub Desktop.
MySQL dumping and restoring in java
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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(); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
it doesn't work for me.
process.waitFor() never finishes and nothing is written to the backup file.