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
Post a Comment