Advertisement
Guest User

Untitled

a guest
Mar 5th, 2017
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. private static String ip = "localhost";
  2. private static String port = "3306";
  3. private static String database = "IMS";
  4. private static String user = "root";
  5. private static String pass = "pass";
  6. private static String path = "/home/user/Desktop/project/";
  7.  
  8. public static void backup() {
  9. Date dateNow = new Date();
  10. SimpleDateFormat dateformatyyyyMMdd = new SimpleDateFormat("yyyyMMdd");
  11. String date_to_string = dateformatyyyyMMdd.format(dateNow);
  12. System.out.println("date into yyyyMMdd format: " + date_to_string);
  13. String ss = "IMS.sql";
  14. String fullName = path + " " + date_to_string + " " + ss;
  15. String dumpCommand = "mysqldump " + database + " -h " + ip + " -u " + user + " -p" + pass;
  16. Runtime rt = Runtime.getRuntime();
  17. File test = new File(fullName);
  18. PrintStream ps;
  19. try {
  20. Process child = rt.exec(dumpCommand);
  21. ps = new PrintStream(test);
  22. InputStream in = child.getInputStream();
  23. int ch;
  24. while ((ch = in.read()) != -1) {
  25. ps.write(ch);
  26. //System.out.write(ch); //to view it by console
  27. }
  28.  
  29. InputStream err = child.getErrorStream();
  30. while ((ch = err.read()) != -1) {
  31. System.out.write(ch);
  32. }
  33. } catch (Exception exc) {
  34. exc.printStackTrace();
  35. }
  36. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement