Error in backup of MySQL from Java

Question

I have developed a Java application and it's in last stage.

The problem is that I cannot execute the mysqldump with Runtime.getRuntime().exec().

try {
    String[] command = new String[] {
        "cmd.exe",
        "/c",
        "mysqldump --host=" + host + " --user=" + dbuser + " --password=" + dbpass + " " + dbname + " > " + filename
    };
    Process runtimeProcess = Runtime.getRuntime().exec(command);
    int ProcessComplete = runtimeProcess.waitFor();
    if (ProcessComplete == 0) {
        JOptionPane.showMessageDialog(null, "Database backup has been done successfully");
    }
    else {
        JOptionPane.showMessageDialog(null, "Database backup was unsuccessfull");
        JOptionPane.showMessageDialog(null, command);
    }
}
catch (IOException | InterruptedException exc) {
    Logger.getLogger(Backup.class.getName()).log(Level.SEVERE, null, exc);
}

Can anyone help me with this?

Can't execute in what way? What happens? What do you expect to happen instead? Is there an exception? On which line? — RealSkeptic
– RealSkeptic, Commented Jul 25, 2015 at 12:10
i got the solution buddy....very long back...thanks for asking' — Shaikh Arbaaz
– Shaikh Arbaaz, Commented Sep 15, 2015 at 11:06

Darshan Patel · Accepted Answer · 2015-07-25 14:03:41Z

1

I tried your code in Windows and it works fine for me.

Open cmd, type mysqldump and hit enter.

If it is executed successfully, that means your code should work properly if your database configuration is correct.

If you get 'mysqldump' is not recognized as an internal or external command then either you have to set the MySQL path in your environment variable, or specify the full path for mysqldump in your Java code like this:

String[] command  = new String[] {
    "cmd.exe",
    "/c",
    "c://mysql/bin/mysqldump --host=" + host + " --user=" + dbuser + " --password=" + dbpass + " " + dbname + " > " + filename
};

edited Jul 25, 2015 at 14:03

answered Jul 25, 2015 at 12:58

Darshan Patel

2,9272 gold badges27 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error in backup of MySQL from Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related