mysql java 备份

import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;

public class JavaMysql {

/**
  *
  * mysql数据备份 接收脚本名，并返回此路径
  *
  * sql为备份的脚本名比如xxx.sql
  *
  */

public static void backup(String sql) {

  Properties pros = getPprVue("prop.properties");

  // 这里是读取的属性文件，也可以直接使用

  String username = pros.getProperty("username");

  String password = pros.getProperty("password");

  // 得到MYSQL的用户名密码后调用 mysql 的 cmd:

  String mysqlpaths = pros.getProperty("mysqlpath");
  String databaseName = pros.getProperty("databaseName");
  String address = pros.getProperty("address");
  String sqlpath = pros.getProperty("sql");
  File backupath = new File(sqlpath);
  if (!backupath.exists()) {
   backupath.mkdir();
  }

  StringBuffer sb = new StringBuffer();

  sb.append(mysqlpaths);
        sb.append("mysqldump ");
  sb.append("--opt ");
  sb.append("-h ");
  sb.append(address);
  sb.append(" ");
  sb.append("--user=");
  sb.append(username);
  sb.append(" ");
  sb.append("--password=");
  sb.append(password);
  sb.append(" ");
  sb.append("--lock-all-tables=true ");
  sb.append("--result-file=");
  sb.append(sqlpath);
  sb.append(sql);
  sb.append(" ");
  sb.append("--default-character-set=utf8 ");
  sb.append(databaseName);
  Runtime cmd = Runtime.getRuntime();
  try {
   Process p = cmd.exec(sb.toString());
  } catch (IOException e) {
   e.printStackTrace();
  }

}

// 读取属性值

public static Properties getPprVue(String properName) {

  InputStream inputStream = mysql_util.class.getClassLoader()

  .getResourceAsStream(properName);

  Properties p = new Properties();

  try {
   p.load(inputStream);
   inputStream.close();
  } catch (IOException e) {
   e.printStackTrace();
  }

  return p;

}

public static void load(String filename) {
  Properties pros = getPprVue("prop.properties");

  // 这里是读取的属性文件，也可以直接使用

  String root = pros.getProperty("jdbc.username");

  String pass = pros.getProperty("jdbc.password");

  // 得到MYSQL的用户名密码后调用 mysql 的 cmd:

  String mysqlpaths = pros.getProperty("mysqlpath");
  String sqlpath = pros.getProperty("sql");
  String filepath = sqlpath + filename; // 备份的路径地址

  // 新建数据库finacing
  String stmt1 = "mysqladmin -u " + root + " -p" + pass
    + " create finacing";
  // -p后面加的是你的密码
  String stmt2 = "mysql -u " + root + " -p" + pass + " finacing < "
    + filepath;
  String[] cmd = { "cmd", "/c", stmt2 };

  try {
   Runtime.getRuntime().exec(stmt1);
   Runtime.getRuntime().exec(cmd);
   System.out.println("数据已从 " + filepath + " 导入到数据库中");
  } catch (IOException e) {
   e.printStackTrace();
  }

}

public static void main(String[] args) throws IOException {

   backup("xx.sql");

  //load("xx.sql");
}
}







---------------------------------------prop.properties



username = root
password = root
mysqlpath = C:\\Program Files\\MySQL\\MySQL Server 5.0\\bin\\
sql = E:\\MySQl\\
address=localhost
databaseName=test


本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/lpdx111/archive/2008/12/07/3462308.aspx