windows上java备份mysql和还原mysql数据库

windows下java备份mysql和还原mysql数据库

import java.io.File;import java.io.FileInputStream;import java.io.IOException;import java.util.Properties;public class SqlManage {public static void main(String[] args){Properties p = new Properties();FileInputStream in;try {in = new FileInputStream(new File("property/config.properties"));p.load(in);//backup(p.getProperty("backup.path"));restory(p.getProperty("restory.path"));} catch (Exception e) {e.printStackTrace();}}                

                 //从标准的导出的sql文件进行还原private static void restory(String path) {Runtime r = Runtime.getRuntime();String command = "mysql -uroot -p123456 talk < "+path;String[] cmd = {"cmd","/c",command};try {r.exec(cmd);} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}}

                //从mysql到处sql文件private static void backup(String path) {Runtime r = Runtime.getRuntime();//获得运行的java对象String encoding = System.getProperty("file.encoding");    String command = "cmd.exe /c "mysqldump -uroot -p123456 --default-character-set="+encoding+"  talk > "+path+""";Process p;    try {p = r.exec(command);} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}    System.exit(0);}}

?

1 楼 zhangpeili 2012-07-30   你好！你那个mysqdump放在那里了！配置环境变量了吗 2 楼 pengjj2 2012-09-17   zhangpeili 写道你好！你那个mysqdump放在那里了！配置环境变量了吗
额好久没来了，没有额，mysqdump是个命令，应该就在安装文件夹下吧，环境变量，java的？mysqlMS不需要配置吧

查看更多 下一篇