在尝试使用Java进行MYSQL自动备份时,我不断收到以下错误,整个上午都在尝试变通。该系统是WindowsXP SP3,运行Apache Tomcat 6和Java 1.6.25
我一直收到这个错误:
ERROR com.busytech.barba.exception.BarbaException – java.io.IOException: Cannot run program “C:Program”: CreateProcess error=2, The system cannot find the file specified
com.busytech.barba.exception.BarbaException: Cannot run program “C:Program”: CreateProcess error=2, The system cannot find the file specified
at com.busytech.barba.persistence.BackUpAndRestoreDatabaseManager.getTableBackup(BackUpAndRestoreDatabaseManager.java:52)
at com.busytech.barba.servlet.checkcash.CashSummaryServlet.processRequest(CashSummaryServlet.java:95)
at com.busytech.barba.servlet.checkcash.CashSummaryServlet.doPost(CashSummaryServlet.java:495)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:864)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665)
at java.lang.Thread.run(Unknown Source)
java.io.IOException: Cannot run program “C:Program”: CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessBuilder.start(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at com.busytech.barba.persistence.BackUpAndRestoreDatabaseManager.getTableBackup(BackUpAndRestoreDatabaseManager.java:30)
at com.busytech.barba.servlet.checkcash.CashSummaryServlet.processRequest(CashSummaryServlet.java:95)
at com.busytech.barba.servlet.checkcash.CashSummaryServlet.doPost(CashSummaryServlet.java:495)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:864)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessImpl.create(Native Method)
at java.lang.ProcessImpl.(Unknown Source)
at java.lang.ProcessImpl.start(Unknown Source)
… 21 more
347156 [http-8080-4] ERROR com.busytech.barba.exception.BarbaException – java.io.IOException: Cannot run program “C:Program”: CreateProcess error=2, The system cannot find the file specified
com.busytech.barba.exception.BarbaException: Cannot run program “C:Program”: CreateProcess error=2, The system cannot find the file specified
at com.busytech.barba.persistence.BackUpAndRestoreDatabaseManager.getTableBackup(BackUpAndRestoreDatabaseManager.java:52)
at com.busytech.barba.servlet.checkcash.CashSummaryServlet.processRequest(CashSummaryServlet.java:95)
at com.busytech.barba.servlet.checkcash.CashSummaryServlet.doPost(CashSummaryServlet.java:495)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:864)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1665)
at java.lang.Thread.run(Unknown Source)
这是一个补充:这就是我所做的尝试{
Process run = null;
if (System.getProperty("os.name").toLowerCase().contains("window")) {
run = Runtime.getRuntime().exec(SystemInformation.getWindowsMySQLDump() + " --host=" + host + " --port=" + port
+ " --user=" + user + " --password=" + password
+ " --compact --complete-insert --extended-insert "
+ "--skip-comments --skip-triggers --skip-lock-tables --single-transaction " + database + " " + table);
} else {
run = Runtime.getRuntime().exec("mysqldump --host=" + host + " --port=" + port
+ " --user=" + user + " --password=" + password
+ " --compact --complete-insert --extended-insert "
+ "--skip-comments --skip-triggers --skip-lock-tables --single-transaction " + database + " " + table);
}
InputStream in = run.getInputStream();
BufferedReader br = new BufferedReader(new InputStreamReader(in));
int count;
char[] cbuf = new char[BUFFER];
while ((count = br.read(cbuf, 0, BUFFER)) != -1) {
temp.append(cbuf, 0, count);
}
br.close();
in.close();
} catch (Exception e) {
e.printStackTrace();
}
不确定这是MySQL或备份问题,但来自错误:
无法运行程序"C:\program"
看起来你好像忘记在某个字符串周围加引号了。
如果您尝试运行
c:program filesmyappsomething.exe
那么它可能会在第一个空间分裂,所以您正在尝试执行c:program
——我怀疑它是否是一个实际的可执行文件。尝试
"c:program filesmyappsomething.exe"
问题是您的应用程序(在您的情况下可能是MySQL)的安装路径。
C: \Program Files\MySQL\bin\MySQL.exe
"程序文件"中的空白导致了问题,并且您没有在上面加引号。
"C:\Program Files\MySQL\bin\MySQL.exe"
您可以使用ApacheExec从Java启动进程。这可以处理从Java应用程序启动进程时可能出错的所有常见问题
如果你能提供进一步的信息,你将如何开始这个过程。
以下是我的建议(使用ApacheCommonsExec的实现)。
CommandLine cmdLine = CommandLine.parse("C:\Program Files\MySQL\bin\mysqldump");
cmdLine.addArgument("--user=");
// add further args here
Executor executor = new DefaultExecutor();
OutputStream stdOut = new ByteArrayOutputStream();
PumpStreamHandler psh = new PumpStreamHandler(stdOut);
executor.setStreamHandler(psh);
try {
int exitCode = executor.execute(cmdLine);
String output = stdOut.toString();
BufferedReader lineReader = new BufferedReader(new StringReader(output));
String line;
while ((line = lineReader.readLine()) != null) {
log.debug("Reading line #{} - '{}'", lineCount, line);
}
} catch (IOException e) {
// handle the exception
}
这是我使用的解决方案,它的工作原理与windows和linux类似,上面建议使用apache-commons-exec:
String cmdline = "mysqldump";
DefaultExecuteResultHandler resultHandler = new DefaultExecuteResultHandler();
CommandLine commandLine = CommandLine.parse(cmdline);
commandLine.addArgument("--host=" + dbhost);
commandLine.addArgument("--port=" + dbport);
commandLine.addArgument("--user=" + dbuser);
commandLine.addArgument("--password=" + dbpass);
commandLine.addArgument(database);
Set keys = table.keySet();
for (Iterator i = keys.iterator(); i.hasNext();) {
String key = (String) i.next();
String value = (String) table.get(key);
commandLine.addArgument(value);
}
commandLine.addArgument("-r");
//outputFile might be a file on the server that can be downloaded
//used apache file upload to download the files from the server
commandLine.addArgument(outputFile);
Executor executor = new DefaultExecutor();
executor.execute(commandLine, resultHandler);
resultHandler.waitFor();
要将文件恢复到服务器,请上传文件,这是从mysqldumpfile恢复的代码,如果在windows上的环境变量上只设置了mysql路径,那么这就可以了,但在linux上,它可以像一样工作
String cmdline = "mysql";
DefaultExecuteResultHandler resultHandler = new DefaultExecuteResultHandler();
CommandLine commandLine = CommandLine.parse(cmdline);
commandLine.addArgument("--user=" + dbuser);
commandLine.addArgument("--password=" + dbpass);
commandLine.addArgument("--force");
commandLine.addArgument("-v");
commandLine.addArgument("-e");
commandLine.addArgument("source");
commandLine.addArgument(backUpFile);
commandLine.addArgument(database);
Executor executor = new DefaultExecutor();
executor.execute(commandLine, resultHandler);
resultHandler.waitFor();