java - Take MySQL backup -


i need avoid error , store database backup in separate file path using mysqldump

public class newclass {      public static void main(string args[]) throws ioexception, sqlexception {         string dbname = "test";         string dbuser = "root";         string dbpass = "root";         try {             string executecmd = "";             executecmd = "mysqldump -u " + dbuser + " -p" + dbpass + " " + dbname + " -r 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 (interruptedexception ex) {             logger.getlogger(newclass.class.getname()).log(level.severe, null, ex);         }          } } 

error:run: exception in thread "main" java.io.ioexception: cannot run program "mysqldump": createprocess error=2, system cannot find file specified @ java.lang.processbuilder.start(processbuilder.java:1042) @ java.lang.runtime.exec(runtime.java:615) @ java.lang.runtime.exec(runtime.java:448) @ java.lang.runtime.exec(runtime.java:345) @ mypkg.newclass.main(newclass.java:27) caused by: java.io.ioexception: createprocess error=2, system cannot find file specified @ java.lang.processimpl.create(native method) @ java.lang.processimpl.(processimpl.java:288) @ java.lang.processimpl.start(processimpl.java:133) @ java.lang.processbuilder.start(processbuilder.java:1023) ... 4 more java result: 1 build successful (total time: 0 seconds)

try putting full path mysqldump program

executecmd = "/full/path/to/mysqldump -u " + dbuser + " -p" + dbpass + " " + dbname + " -r backup.sql"; 

i'd tempted put full path file dump written well.


Comments