linux和windonw下mysql备份java

1.环境centos6.7 +mysql5.6.28

2.环境win7+mysql5.5

package test.service;

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;

public class TestMysql {

	public static void main(String[] args) {
		System.out.println("开始备份...");
		backup();
		System.out.println("备份成功...");

		// System.out.println("开始还原...");
		// load1();
		// System.out.println("还原成功...");
	}

	public static void backup() {
		try {
			Runtime rt = Runtime.getRuntime();
			// 调用 调用mysql的安装目录的命令
			//------------------------------window7--------
			// Process child =rt.exec("D://MySQL//MySQL Server 5.5//bin//mysqldump -h 192.168.50.100 -uroot -p123456  test1");
			//------------------------------centos6.7--------
			Process child = rt.exec("/usr/bin/mysqldump -h 192.168.50.100 -uroot -p123456  test1");
			// 设置导出编码为utf-8。这里必须是utf-8
			// 把进程执行中的控制台输出信息写入.sql文件，即生成了备份文件。注：如果不对控制台信息进行读出，则会导致进程堵塞无法运行
			InputStream in = child.getInputStream();// 控制台的输出信息作为输入流
			InputStreamReader xx = new InputStreamReader(in, "utf-8");
			// 设置输出流编码为utf-8。这里必须是utf-8，否则从流中读入的是乱码
			String inStr;
			StringBuffer sb = new StringBuffer("");
			String outStr;
			// 组合控制台输出信息字符串
			BufferedReader br = new BufferedReader(xx);
			while ((inStr = br.readLine()) != null) {
				sb.append(inStr + "\r\n");
			}
			outStr = sb.toString();
			// 要用来做导入用的sql目标文件：
			//------------------------------window7--------
			// FileOutputStream fout = new FileOutputStream("d:/test20160630_111.sql");
			//------------------------------centos6.7--------
			FileOutputStream fout = new FileOutputStream("/home/rzrenyu/test20160630.sql");
			OutputStreamWriter writer = new OutputStreamWriter(fout, "utf-8");
			writer.write(outStr);
			writer.flush();
			in.close();
			xx.close();
			br.close();
			writer.close();
			fout.close();
			System.out.println("");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}
           

参考：http://blog.sina.com.cn/s/blog_694448320100ulzv.html