linux下java还原mysql数据库

最新推荐文章于 2024-06-13 09:44:31 发布

weixin_33919941

最新推荐文章于 2024-06-13 09:44:31 发布

阅读量263

点赞数

文章标签：数据库 java runtime

原文链接：https://my.oschina.net/sfilyh/blog/82769

版权

为什么80%的码农都做不了架构师？>>>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    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</data/backup.sql";	
	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]

http://tuhaitao.iteye.com/blog/1047820

转载于:https://my.oschina.net/sfilyh/blog/82769