Error in executing mysql command from java

Question

I was trying to execute the mysql command using java but this always keeps giving error.

    String dbName = "dth";
    String dbUser = "root";
    String dbPass = "root";

    String executeCmd = "";
    executeCmd = "mysqldump -u " + dbUser + " -p" + dbPass + " " + dbName + " -r    C:\\backup.sql";

    Process runtimeProcess = Runtime.getRuntime().exec(executeCmd);
    int processComplete = runtimeProcess.waitFor();
    if (processComplete == 0) {
        System.out.println("Backup taken successfully");
    } else {
        System.out.println("Could not take mysql backup");
    }

} catch (Exception e) {
    System.out.println(e.getMessage());
}

I tried the above code but I couldn't get it done, keeps giving me

CreateProcess error=2, The system cannot find the file specified error.

I have tried it by creating a .sql file on the location and still I get the same error.

Could it be that it fails to find mysqldump? Perhaps it's not in your path? — kufudo
– kufudo, Commented Feb 17, 2013 at 4:46
I think its similar to thread.... stackoverflow.com/questions/13376132/… — Amit
– Amit, Commented Feb 17, 2013 at 4:52
I did that but now it causes the program to never stop. i.e. It starts, it does create a backup.sql file but it never stops! like an infinite loop. — chettyharish
– chettyharish, Commented Feb 17, 2013 at 5:06

Bushbert · Accepted Answer · 2013-02-17 04:54:27Z

1

Add the directory in which mysqldump resides into your path environment variable or use the full pathname I.e c:\directory\mysqldump

answered Feb 17, 2013 at 4:54

Bushbert

1589 bronze badges

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

7 Comments

chettyharish Over a year ago

I did that but now it causes the program to never stop. i.e. It starts, it does create a backup.sql file but it never stops! like an infinite loop.

Bushbert Over a year ago

Are you sure it's just not waiting for the dump to finish? I would check the running processes to make sure it's done.

chettyharish Over a year ago

ok it was not that, I was experimenting with the string and left a space after the -p and caused the infinite error.

chettyharish Over a year ago

One more question why the backup from PHPmyadmin is like 3.5MB and from mysqldump only 27Kb? is there anything missing?

Bushbert Over a year ago

Thats not right, I'm not a mysql expert but the -r option in your command doesnt look right. Try replacing "-r" with ">".

|

Collectives™ on Stack Overflow

Error in executing mysql command from java

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related