pageEncoding="UTF-8" import="java.lang.*,java.io.*,java.util.*"%>

Runtime runtime = Runtime.getRuntime();

// 將/data/backup.sql 還原到 192.168.0.96 上的demo庫 賬號密碼為 root root

String restore = "mysql -u root -proot -h 192.168.0.96 demo

String[] command = new String[]{"/bin/bash","-c",restore};

Process process = runtime.exec(command);

// 輸出執行結果

InputStreamReader in = new InputStreamReader(process.getInputStream());

BufferedReader br = new BufferedReader(in);

String line = null;

while((line = br.readLine()) != null){

System.out.println(line);

}

br.close();

in.close();

// 輸出錯誤信息

InputStreamReader in2 = new InputStreamReader(process.getErrorStream());

BufferedReader br2 = new BufferedReader(in2);

String line2 = null;

while((line2 = br2.readLine()) != null){

System.out.println("="+line2);

}

br2.close();

in2.close();

%>

[為什么加/bin/bash -c]

總結

以上是生活随笔為你收集整理的mysql linux 还原_linux下java还原mysql数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。