java 后端备份数据库数据

ProcessBuilder processBuilder = new ProcessBuilder(
                "mysqldump",
                "--user=" + mqyslusername,//数据库用户
                "--password=" + mqyslpassword,//数据库用户密码
                "--databases",
                mqyslkname,//数据库名称
                "--result-file=" + reservedpath+rename//保存的路径，以及保存后的文件名
        );

  Process process = processBuilder.start();
        BufferedReader reader = new BufferedReader(new InputStreamReader(process.getInputStream()));
        String line;

        while ((line = reader.readLine()) != null) {
            System.out.println(line);
        }

        int exitCode = process.waitFor();
        if (exitCode == 0) {
            System.out.println("数据库备份成功！");
        } else {
            System.out.println("数据库备份失败！");
        }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23