java 程序备份MySQL数据库

最新推荐文章于 2024-05-07 10:29:20 发布

kong0609

最新推荐文章于 2024-05-07 10:29:20 发布

阅读量372

点赞数

文章标签： mysql java string 数据库 null c

本文链接：https://blog.csdn.net/kong0609/article/details/6267204

版权

private static void backup() {

  Runtime rt = Runtime.getRuntime();
  Process child = null;
  try {
   child = rt
     .exec("C://Program Files//MySQL//MySQL Server 5.5//bin//mysqldump -uroot -padmin crmsure");
  } catch (IOException e) {
   e.printStackTrace();
   System.out.println("备份命令执行错误");
  }
  InputStream in = child.getInputStream();
  InputStreamReader sr = null;
  try {
   sr = new InputStreamReader(in, "utf8");
  } catch (UnsupportedEncodingException e) {
   e.printStackTrace();
   System.out.println("读输入流错误");
  }
  String inStr;
  StringBuffer sb = new StringBuffer("");
  String outStr;
  BufferedReader br = new BufferedReader(sr);
  try {
   while ((inStr = br.readLine()) != null) {
    sb.append(inStr + "/r/n");
   }
  } catch (IOException e) {
   e.printStackTrace();
   System.out.println("缓冲读出错误");
  }
  outStr = sb.toString();
  FileOutputStream fout = null;
  try {
   fout = new FileOutputStream("d:/xytx.sql");
  } catch (FileNotFoundException e) {
   e.printStackTrace();
   System.out.println("文件路径错误");
  }
  OutputStreamWriter writer=null;
  try {
    writer=new OutputStreamWriter(fout, "utf8");
  } catch (UnsupportedEncodingException e) {
   e.printStackTrace();
   System.out.println("文件流写出错误");
  }
  try {
   writer.write(outStr);
   writer.flush();
   in.close();
   sr.close();
   writer.close();
   fout.close();
   System.out.println("备份成功");
  } catch (IOException e) {
   e.printStackTrace();
   System.out.println("流关闭错误");
  }


}