java 调用命令行 备份mysql数据库

来源:互联网 发布:摄像头电脑监控器软件 编辑:程序博客网 时间:2024/04/16 18:13

// 方式1String command = "D:\\mysql\\bin\\mysqldump -h127.0.0.1 -uroot -p -ntd -R -dbname";Runtime runtime = Runtime.getRuntime();Process process = runtime.exec(command);InputStreamReader reader = new InputStreamReader(process.getInputStream());BufferedReader buffReader = new BufferedReader(reader);String inStr;String outStr;StringBuffer buffer = new StringBuffer();while ((inStr = buffReader.readLine()) != null) {buffer.append(inStr + "\r\n");}outStr = buffer.toString();OutputStream os = new FileOutputStream("D:\\sql.sql");OutputStreamWriter writer = new OutputStreamWriter(os);writer.write(outStr);writer.flush();reader.close();buffReader.close();os.close();writer.close();// 方式2String command = "cmd /c mysqldump -h127.0.0.1 -uroot -p -ntd -R -dbname";Runtime runtime = Runtime.getRuntime();Process process = runtime.exec(command, null,new File("D:\\mysql\\bin"));InputStreamReader reader = new InputStreamReader(process.getInputStream());BufferedReader buffReader = new BufferedReader(reader);String inStr;String outStr;StringBuffer buffer = new StringBuffer();while ((inStr = buffReader.readLine()) != null) {buffer.append(inStr + "\r\n");}outStr = buffer.toString();OutputStream os = new FileOutputStream("D:\\sql.sql");OutputStreamWriter writer = new OutputStreamWriter(os);writer.write(outStr);writer.flush();reader.close();buffReader.close();os.close();writer.close();