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 block
			e.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 block
			e.printStackTrace();
		}
	    System.exit(0);
		
	}

}

 

评论

2 楼 pengjj2 2012-09-17  

zhangpeili 写道

你好！你那个mysqdump放在那里了！配置环境变量了吗

额好久没来了，没有额，mysqdump是个命令，应该就在安装文件夹下吧，环境变量，java的？mysqlMS不需要配置吧

1 楼 zhangpeili 2012-07-30  

你好！你那个mysqdump放在那里了！配置环境变量了吗