Advertisement
Guest User

Export Databse

a guest
Apr 6th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.91 KB | None | 0 0
  1.     public void exportDatabase()
  2.     {
  3.         String dbName = "test";
  4.         String dbUser = "root";
  5.         String dbPass = "root";
  6.  
  7.         /***********************************************************/
  8.         // Execute Shell Command
  9.         /***********************************************************/
  10.         String executeCmd = "";
  11.         String m_MySqlPath = "C:\\Program Files (x86)\\MySQL\\MySQL Server 5.7\\bin";
  12.        
  13.         try {
  14.             executeCmd = m_MySqlPath + "\\mysqldump -u " + dbUser
  15.                       +" -p" + dbPass + " " + dbName + " -r " + "\""+ "./backup.sql\"";
  16.             Process runtimeProcess = Runtime.getRuntime().exec(executeCmd, null);
  17.              BufferedReader r=new BufferedReader(new InputStreamReader(runtimeProcess.getInputStream()));
  18.                 String s;
  19.                 while((s=r.readLine())!=null)
  20.                 {
  21.                     System.out.println(s);
  22.                 }
  23.         } catch (IOException e) {
  24.             // TODO Auto-generated catch block
  25.             e.printStackTrace();
  26.         }
  27.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement