mysql还原数据库:java.io.IOException: 管道已结束

来源:互联网 发布:c语言嵌入式开发 编辑:程序博客网 时间:2024/06/05 08:15

Runtime runtime = Runtime.getRuntime();
Process process = runtime.exec("C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin\\mysql.exe -hlocalhost -uroot -p1234 --default-character-set=utf8 buddha");
OutputStream outputStream = process.getOutputStream();
BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream("C:\\backup\\buddha.sql"),"utf-8"));
String str = null;
StringBuffer sb = new StringBuffer();
while((str = br.readLine()) != null){
sb.append(str+"\r\n");
}
str = sb.toString();
System.out.println(str);
OutputStreamWriter writer = new OutputStreamWriter(outputStream,"utf-8");
writer.write(str);
writer.flush();
outputStream.close();
br.close();
writer.close();

编码需要一致,否则会报管道关闭的错误。

0 0
原创粉丝点击