Windows环境下

在 RyTask 类下添加以下方法

public void windowsDump(String dir, String host, String port, String username, String password, String databasename) throws Exception {File file = new File(dir);if (!file.exists()) {file.mkdir();}String sqlname = new SimpleDateFormat("yyyy-MM-dd-HH-mm-ss").format(new Date());File datafile = new File(file + File.separator + sqlname + ".sql");if (datafile.exists()) {System.out.println(sqlname + "文件名已存在，请更换");return;}//拼接cmd命令  windows下 cmd   Linux下 /bin/shProcess exec = Runtime.getRuntime().exec("cmd /c /usr/bin/mysqldump -h" + host + " -P" + port + " -u " + username + " -p" + password + " " + databasename + " > " + datafile);if (exec.waitFor() == 0) {System.out.println("数据库备份成功,备份路径为：" + datafile);}}

然后启动项目进行如下配置

Linux环境下

public void linuxDump(String dir, String host, String port, String username, String password, String databasename) throws Exception {File file = new File(dir);if (!file.exists()) {file.mkdir();}String sqlname = new SimpleDateFormat("yyyy-MM-dd-HH-mm-ss").format(new Date());File datafile = new File(file + File.separator + sqlname + ".sql");if (datafile.exists()) {System.out.println(sqlname + "文件名已存在，请更换");return;}//拼接cmd命令  windows下 cmd   Linux下 /bin/shProcess exec = Runtime.getRuntime().exec(new String[]{"/bin/sh", "-c", "/usr/bin/mysqldump -h" + host + " -P" + port + " -u " + username + " -p" + password + " " + databasename + " > " + datafile});if (exec.waitFor() == 0) {System.out.println("数据库备份成功,备份路径为：" + datafile);}}

配置方式和Windows类似