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

2011-12-21 01:42:44 319 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

SRv6项目实践（三）：P4Runtime基础以及交换机控制在正式介绍P4runtime基础之前，先说一说P4的编译和实现的过程该文件包含了各个表和操作，它们的id用一个索引值来表示，比如a表用b操作，不会直接说用名字为B的操作，而是说用索引为xxx的操作，然后锁定到b上执行相关的功能，其次，用了一个bitwith来描述，要访问的数据的比特长度是多长。p4c编译器将p4编译成两份文件，其中一份是，另一份是，将这两个文件再整合起来，作为配置，放到交换机中。阅读详情



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();

	}

}

备份数据可以正常备份，但是恢复就出来了，搞不懂是为什么，下面是错误代码：



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)

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

...全文