日期:2014-05-16  浏览次数:20521 次

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);
		
	}

}

?

1 楼 zhangpeili 2012-07-30  
你好!你那个mysqdump放在那里了!配置环境变量了吗
2 楼 pengjj2 2012-09-17  
zhangpeili 写道
你好!你那个mysqdump放在那里了!配置环境变量了吗

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