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