mysql 还原 java_java还原mysql

public boolean restore(BackupDto dto) throws Exception {

OutputStream out = null;

BufferedReader br = null;

OutputStreamWriter writer = null;

try {

String fPath = dto.getPath();

Runtime rt = Runtime.getRuntime();

String rootPath = WebUtil.getMysqlRoot();

logger.debug("My SQL bin path:" + rootPath);

String s = "" + rootPath+"bin\\mysql.exe -uroot -p123 logistics";

Process child = rt.exec(s);

out = child.getOutputStream();// 控制台的输入信息作为输出流

String inStr;

StringBuffer sb = new StringBuffer("");

String outStr;

br = new BufferedReader(new InputStreamReader(

new FileInputStream(fPath), "utf8"));

while ((inStr = br.readLine()) != null) {

sb.append(inStr + "\r\n");

}

outStr = sb.toString();

writer = new OutputStreamWriter(out, "utf8");

writer.write(outStr);

writer.flush();

out.close();

br.close();

writer.close();

logger.info("restore successfully.");

} catch (Exception e) {

logger.error(e);

return false;

} finally {

out.close();

br.close();

writer.close();

}

return true;

}

分享到：

2009-03-04 00:42

浏览 952

评论

发表评论

文章已被作者锁定，不允许评论。