Advertisement
Guest User

Untitled

a guest
Feb 28th, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.73 KB | None | 0 0
  1. Runtime runtime = Runtime.getRuntime();
  2. runtime.exec("C:\Program Files\MySql\MySql Server 5.5\bin\mysqldump -u root -p myDatabase> D:\backup.sql");
  3.  
  4. runtime.exec(new String[]{"C:\Program Files\MySql\MySql Server 5.5\bin\mysqldump", "-u", "root", "-pmyDatabase" "> D:\backup.sql"});
  5.  
  6. /******************************************************/
  7. //Database Properties
  8. /******************************************************/
  9. String dbName = “dbName”;
  10. String dbUser = “dbUser”;
  11. String dbPass = “dbPass”;
  12.  
  13. /***********************************************************/
  14. // Execute Shell Command
  15. /***********************************************************/
  16. String executeCmd = “”;
  17. executeCmd = “mysqldump -u “+dbUser+” -p”+dbPass+” “+dbName+” -r backup.sql”;
  18. }
  19. Process runtimeProcess =Runtime.getRuntime().exec(executeCmd);
  20. int processComplete = runtimeProcess.waitFor();
  21. if(processComplete == 0){
  22.  
  23. out.println(“Backup taken successfully”);
  24.  
  25. } else {
  26.  
  27. out.println(“Could not take mysql backup”);
  28.  
  29. }
  30.  
  31. /******************************************************/
  32. //Database Properties
  33. /******************************************************/
  34. String dbName = “dbName”;
  35. String dbUser = “dbUser”;
  36. String dbPass = “dbPass”;
  37.  
  38. /***********************************************************/
  39. // Execute Shell Command
  40. /***********************************************************/
  41. String executeCmd = “”;
  42.  
  43. executeCmd = new String[]{“/bin/sh”, “-c”, “mysql -u” + dbUser+ ” -p”+dbPass+” ” + dbName+ ” < backup.sql” };
  44.  
  45. }
  46. Process runtimeProcess =Runtime.getRuntime().exec(executeCmd);
  47. int processComplete = runtimeProcess.waitFor();
  48. if(processComplete == 0){
  49.  
  50. out.println(“success”);
  51.  
  52. } else {
  53.  
  54. out.println(“restore failure”);
  55.  
  56. }
  57.  
  58. public void actionPerformed(ActionEvent evt)
  59. {
  60. private String m_MySqlPath="";
  61. ResultSet res=null;
  62. res = DBHandler.getInstance().executeQuery("select @@basedir",null);
  63.  
  64. while(res.next())
  65. {
  66. m_MySqlPath=res.getString(1) ;
  67. }
  68.  
  69.  
  70.  
  71. m_MySqlPath = m_MySqlPath.replace("\Data\", "\bin\");
  72.  
  73. if (exportDB.isSelected()
  74. {
  75. try {
  76.  
  77. String executeCmd = m_MySqlPath + "\mysqldump -u " + DB_USER
  78. +" -p" + DB_PASSWORD + " " + DB_NAME + " -r " + """+FilePath + "\"
  79. + FileName+""";
  80.  
  81. Process runtimeProcess = Runtime.getRuntime().exec(executeCmd, null);
  82.  
  83. BufferedReader r=new BufferedReader(new InputStreamReader(runtimeProcess.getInputStream()));
  84. String s;
  85. while((s=r.readLine())!=null)
  86. {
  87. System.out.println(s);
  88. }
  89.  
  90. return true;
  91.  
  92. }
  93. catch (final Exception ex) {
  94. ex.printstackTrace();
  95. return false;
  96. }
  97. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement