当前位置: 代码迷 >> Java Web开发 >> Java来恢复MySql数据,但是报错了什么管道已结束,找了好久都没找到原因。哎。该怎么处理
  详细解决方案

Java来恢复MySql数据,但是报错了什么管道已结束,找了好久都没找到原因。哎。该怎么处理

热度:78   发布时间:2016-04-17 11:07:32.0
Java来恢复MySql数据,但是报错了什么管道已结束,找了好久都没找到原因。。哎。
Java code
package com.hancai.base.admin.action;import java.io.BufferedReader;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.InputStreamReader;import java.io.OutputStream;import java.io.OutputStreamWriter;public class Test {    public static void main(String[] args) throws IOException{        recover("d:\\fjsdljfls.sql");    }    public static void backup(String path) throws IOException{        Runtime runtime = Runtime.getRuntime();        Process process = runtime.exec("mysqldump -u root -p123456 family");        InputStream inputStream = process.getInputStream();        InputStreamReader reader = new InputStreamReader(inputStream);        BufferedReader br = new BufferedReader(reader);        String s = null;        StringBuffer sb = new StringBuffer();        while((s = br.readLine()) != null){            sb.append(s+"\r\n");        }        s = sb.toString();        System.out.println(s);        File file = new File(path);        file.getParentFile().mkdirs();        FileOutputStream fileOutputStream = new FileOutputStream(file);        fileOutputStream.write(s.getBytes());        fileOutputStream.close();        br.close();        reader.close();        inputStream.close();    }    public static void recover(String path) throws IOException{        Runtime runtime = Runtime.getRuntime();        Process process = runtime.exec("mysql -u root -p123456 family");        OutputStream outputStream = process.getOutputStream();        BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream(path)));        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();    }}

备份数据可以正常备份,但是恢复就出来了,搞不懂是为什么,下面是错误代码:
XML code
Exception in thread "main" java.io.IOException: 管道已结束。    at java.io.FileOutputStream.writeBytes(Native Method)    at java.io.FileOutputStream.write(FileOutputStream.java:260)    at java.io.BufferedOutputStream.write(BufferedOutputStream.java:105)    at sun.nio.cs.StreamEncoder.writeBytes(StreamEncoder.java:202)    at sun.nio.cs.StreamEncoder.implWrite(StreamEncoder.java:263)    at sun.nio.cs.StreamEncoder.write(StreamEncoder.java:106)    at sun.nio.cs.StreamEncoder.write(StreamEncoder.java:116)    at java.io.OutputStreamWriter.write(OutputStreamWriter.java:203)    at java.io.Writer.write(Writer.java:140)    at com.hancai.base.admin.action.Test.recover(Test.java:64)    at com.hancai.base.admin.action.Test.main(Test.java:26)


有没有人跟我一样遇到过这种问题?帮忙解决一下吧。谢谢了。

------解决方案--------------------
没这样搞过。不过我估计是mysql关闭了连接吧,导致你的输出流关闭。
------解决方案--------------------
换mysqldump 
http://topic.csdn.net/u/20100327/01/356ef6c1-0dac-4ca9-8169-80d18f3890f0.html
------解决方案--------------------
用命令恢复比较好吧
  相关解决方案