Backup mysql from remote database with mysqldump process error

Question

I want to make a backup of my remote mysql database. I have viewed many examples, but I can not find the answer what I am doing wrong. I have mysql server on my computer with other name than my remote database, just want to create sql file in my computer to have a copy. My button action performed code is:

try {
            String cs = "jdbc:mysql://db4free.net:3306/DBNAME?user=DBUSER&password=DBPASSWORD";
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            Connection connection = java.sql.DriverManager.getConnection(cs);
            String executeCmd = "";
            if (connection != null) {
                executeCmd = "mysqldump -hwww.db4free.net -u DBUSER -pDBPASSWORD DBNAME > backup.sql";
                Process runtimeProcess = Runtime.getRuntime().exec(new String[] { "cmd.exe", "/c", executeCmd });
                int processComplete = runtimeProcess.waitFor();
                if (processComplete == 0) {
                    JOptionPane.showMessageDialog(rootPane, "OK");
                } else {
                    JOptionPane.showMessageDialog(rootPane, "Didn't make a copy.");
                }
            } else {
                JOptionPane.showMessageDialog(rootPane, "Failed");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

Duplicated stackoverflow.com/questions/13376132/…

Loic Mouchard
– Loic Mouchard

2016-03-08 11:50:54 +00:00
Commented Mar 8, 2016 at 11:50 — Loic Mouchard
– Loic Mouchard, Commented Mar 8, 2016 at 11:50

Mikpa · Accepted Answer · 2016-03-08 11:49:25Z

0

The system cannot find the file specified

Try adding path to the file

            executeCmd = "/usr/bin/mysqldump -hwww.db4free.net -u DBUSER -pDBPASSWORD DBNAME > backup.sql";

answered Mar 8, 2016 at 11:49

Mikpa

1,93215 silver badges20 bronze badges

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

6 Comments

Dainius Java Over a year ago

Nope, I get error - java.io.IOException: Cannot run program "/usr/bin/mysqldump": CreateProcess error=2, The system cannot find the file specified

Mikpa Over a year ago

Where is mysqldump on your machine? Is it installed?

Dainius Java Over a year ago

No. Is there any possibility to just make a *.sql file and not putt it into my local mysql server?

Mikpa Over a year ago

You must have mysqldump on the machine where this code is running. The code starts mysqldump-program

Dainius Java Over a year ago

OK, let's I have checked my work PC and I have a working DB for my other older projects, but it throws me error, that I have mentioned in upper posts. I have checked my pat (echo %PATH%) and there is no path to mysql/bin. I have added it to Path. I updated my programm code above so now it shows me OK. But i do not see any changes in my local db. Why? Does my local db has to have the same name as remote one?

|

Collectives™ on Stack Overflow

Backup mysql from remote database with mysqldump process error

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related