今天有个需求备份mysql数据库,本地用Runtime.getRuntime().exec(“cmd”)执行后发现保存的sql文件是0kb。网上看了很多资料,有说空格原因,不能string写全,要stringbuild来拼cmd等等,喵了个咪啥用没有,换成ProcessBuilder来执行cmd就好了,一下是代码。等有时间在研究
private static void configureTasks() {
// 设置备份文件路径
String fileSql="D:\\back\\"+LocalDate.now()+".sql";
// 构建执行备份的Shell命令
List<String> backupCommand = Arrays.asList(
"C:\\Program Files\\MySQL\\MySQL Server 8.0\\bin\\mysqldump",
"-u", "root",
"-p" + "Akfh@2020",
"--single-transaction",
"--routines",
"--triggers",
"--events",
"--databases", "yanshimould",
"--result-file=" + fileSql
);
ProcessBuilder processBuilder = new ProcessBuilder(backupCommand);
try {
// 执行Shell命令并等待完成
Process process = processBuilder.start();
int exitCode = process.waitFor();
if (exitCode == 0) {
System.out.println("数据库备份成功,备份文件路径:" );
} else {
System.err.println("数据库备份失败,Exit Code:" + exitCode);
}
} catch (IOException | InterruptedException e) {
e.printStackTrace();
}
}