如何在java中实现数据库的自动备份

Question

我想使用java代码备份我的sql db。我正在使用这个代码这个代码ids给出了以下异常

谢谢

java.io.IOException: Cannot run program "mysqldump": CreateProcess error=2, The system cannot find the file specified

 class DbBackup {

    public static void main(String[] args) {


          Process p = null;
            try {
                Runtime runtime = Runtime.getRuntime();
                p = runtime.exec("E:/xampp/mysql/bin/mysqldump -uroot -p'' --add-drop-database -B HighCourt -r " + "G:/JAVAWORK" + "1" + ".sql");

                int processComplete = p.waitFor();

                if (processComplete == 0) {

                    System.out.println("Backup created successfully!");

                } else {
             //       lblMessage.setText("Could not create the backup");
                }


            } catch (Exception e) {
                e.printStackTrace();
            }
    }
    }

Answer 1

运行时不知道在哪里查找mysqldump。

提供它的完整路径。/usr/bin/mysqldump之类的。取决于操作系统。