java执行还原mysql_Java备份&还原MySQL数据库

MySQL在登陆的情况下可以用SOURCE D:\test.sql这种方式来还原数据库，但是没有对应备份的命令，真是醉了。

1. BackupUtil类

package com.building.util;

import java.util.Properties;

import priv.dunhanson.util.RuntimeUtil;

/*

* 数据库备份/还原工具类

*/

public class BackupUtil {

/**

* 导出SQL

* @param properties

*/

public static void ExptSQL(Properties properties){

RuntimeUtil.execte(getExptCmd(properties));

}

/**

* 导入SQL

* @param properties

*/

public static void ImptSQL(Properties properties){

RuntimeUtil.execte(getImptCmd(properties));

}

/**

* 获取导出命令

* @param properties

* @return

*/

public static String getExptCmd(Properties properties){

StringBuffer cmd = new StringBuffer();

cmd.append(getOSCmd()).append(" ");

cmd.append("mysqldump").append(" ");

cmd.append("-h").append(properties.getProperty("ip")).append(" ");

cmd.append("-u").append(properties.getProperty("user")).append(" ");

cmd.append("-p").append(properties.getProperty("password")).append(" ");

cmd.append("-P").append(properties.getProperty("port")).append(" ");

cmd.append(properties.getProperty("database")).append(" ").append(">").append(" ");

cmd.append(properties.getProperty("path")).append(properties.getProperty("filename"));

return cmd.toString();

}

/**

* 获取导入命令

* @param properties

* @return

*/

public static String getImptCmd(Properties properties){

StringBuffer cmd = new StringBuffer();

cmd.append(getOSCmd()).append(" ");

cmd.append("mysql").append(" ");

cmd.append("-h").append(properties.getProperty("ip")).append(" ");

cmd.append("-u").append(properties.getProperty("user")).append(" ");

cmd.append("-p").append(properties.getProperty("password")).append(" ");

cmd.append("-P").append(properties.getProperty("port")).append(" ");

cmd.append(properties.getProperty("database")).append(" ").append("

cmd.append(properties.getProperty("path")).append(properties.getProperty("filename"));

return cmd.toString();

}

/**

* 获取当前系统命令

* @return

*/

public static String getOSCmd(){

String osName = System.getProperty("os.name");

if(osName.contains("Windows")){

return "cmd /c";

}else if(osName.contains("Linux")){

return "sh -c";

}

return "";

}

public static void main(String[] args) {

Properties properties = new Properties();

properties.setProperty("ip", "127.0.0.1");

properties.setProperty("user", "root");

properties.setProperty("password", "123456");

properties.setProperty("port", "3306");

properties.setProperty("database", "test");

properties.setProperty("path", "D:\\");

properties.setProperty("filename", "test.sql");

System.out.println(getExptCmd(properties));

}

}

2. RuntimeUtil类

package priv.dunhanson.util;

public class RuntimeUtil {

/**

* 执行命令

* @param execStr

*/

public static void execte(String execStr){

try {

Runtime.getRuntime().exec(execStr);

} catch (Exception e) {

throw new RuntimeException(e);

}

}

}