这代码运行不了,有错误,这个错误就是我解决不了的问题,还请高手指点一下,先谢了上面那位 java.io.IOException: CreateProcess: mysqldump -u root -p dlqihua8 buildings --set-charset=utf8 error=2 at java.lang.ProcessImpl.create(Native Method) at java.lang.ProcessImpl.<init>(ProcessImpl.java:81) at java.lang.ProcessImpl.start(ProcessImpl.java:30) at java.lang.ProcessBuilder.start(ProcessBuilder.java:451) at java.lang.Runtime.exec(Runtime.java:591) at java.lang.Runtime.exec(Runtime.java:429) at java.lang.Runtime.exec(Runtime.java:326) at com.test.backup(test.java:23) at com.test.main(test.java:15)
Runtime.getRuntime().exec("mysqldump --set-charset=utf8 数据库名 "+表名 --user=root --password= ");
要用这样的代码进行备份,但是提示java.io.IOException: CreateProcess: mysqldump --set-charset=utf8 da table --user=root --password= error=2
backup();
}
public static void backup() {
try {
Runtime rt = Runtime.getRuntime();
// 调用 mysql 的 cmd:
Process child = rt
.exec("mysqldump -u root -p密码 数据库名 表名 --set-charset=utf8 "); // 不加表名为备份整个数据库
InputStream in = child.getInputStream();
InputStreamReader xx = new InputStreamReader(in, "utf8");
String inStr;
StringBuffer sb = new StringBuffer("");
String outStr;
BufferedReader br = new BufferedReader(xx);
while ((inStr = br.readLine()) != null) {
sb.append(inStr + "\r\n");
}
outStr = sb.toString();
// 要用来做导入用的sql目标文件:
FileOutputStream fout = new FileOutputStream(
"c:/test.sql");
OutputStreamWriter writer = new OutputStreamWriter(fout, "utf8");
writer.write(outStr);
writer.flush();
in.close();
xx.close();
br.close();
writer.close();
fout.close();
} catch (Exception e) {
e.printStackTrace();
}
}
java.io.IOException: CreateProcess: mysqldump -u root -p dlqihua8 buildings --set-charset=utf8 error=2
at java.lang.ProcessImpl.create(Native Method)
at java.lang.ProcessImpl.<init>(ProcessImpl.java:81)
at java.lang.ProcessImpl.start(ProcessImpl.java:30)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:451)
at java.lang.Runtime.exec(Runtime.java:591)
at java.lang.Runtime.exec(Runtime.java:429)
at java.lang.Runtime.exec(Runtime.java:326)
at com.test.backup(test.java:23)
at com.test.main(test.java:15)