Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. public boolean backupDB(String dbName, String dbUserName, String dbPassword, String path) {
  2.  
  3. String[] executeCmd = new String[] {
  4. "C:\xampp\mysql\bin\mysqldump.exe ",
  5. "-u",
  6. dbUserName,
  7. "-p",
  8. dbPassword,
  9. "--add-drop-database",
  10. "-B",
  11. dbName,
  12. "-r",
  13. path
  14. };
  15.  
  16. final ProcessBuilder pb = new ProcessBuilder(Arrays.asList(executeCmd));
  17. final Process p;
  18. try {
  19. p = pb.start();
  20. int processComplete = p.waitFor();
  21.  
  22. if (processComplete == 0) {
  23. System.out.println("Backup created successfully");
  24. return true;
  25. } else {
  26. System.out.println("Could not create the backup");
  27. BufferedReader reader = new BufferedReader(new InputStreamReader(p.getErrorStream()));
  28. String line = null;
  29. while ( (line = reader.readLine()) != null) {
  30. System.out.println(line);
  31. }
  32. }
  33. } catch (IOException | InterruptedException e) {
  34. e.printStackTrace();
  35. }
  36. return false;
  37. }
  38.  
  39. int processComplete = p.waitFor();
  40.  
  41. boolean backupDB = backup.backupDB("bd_relatorios", "root", "", "C:\MudinhoX\back.sql");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement