1 package com.learn4j.bat;
public class Backup {
private String user_name;// 数据库用户名
private String user_psw;// 数据库密码
private String db_name;// 需要备份的数据库名
private String host_ip;// 主机IP
private String user_charset;// 字符集
private String backup_path; // 存放备份文件的路径
private String stmt;// 命令
public Backup(String user_name, String user_psw, String db_name,
String host_ip, String user_charset, String backup_path) {
this.user_name = user_name;
this.user_psw = user_psw;
this.db_name = db_name;
// 主机IP;
if (host_ip == null || host_ip.equals(""))
this.host_ip = "localhost";// 默认为本机
else
this.host_ip = host_ip;
// 字符集
if (user_charset == null || user_charset.equals(""))
this.user_charset = " "; // 默认为安装时设置的字符集
else
this.user_charset = " --default-character-set=" + user_charset;
this.backup_path = backup_path;
this.stmt = "c:\\wamp\\bin\\mysql\\mysql5.5.20\\bin\\mysqldump "
+ this.db_name + " -h " + this.host_ip + " -u" + this.user_name
+ " -p" + this.user_psw + this.user_charset + " --result-file="
+ this.backup_path;
}
public boolean backup_run() {
boolean run_result = false;
try {
Runtime.getRuntime().exec(this.stmt);
run_result = true;
} catch (Exception e) {
e.printStackTrace();
}
return run_result;
}
public static void main(String[] args) {
Backup backup = new Backup("root", "123456", "student", null, "utf8",
"d:\\test.sql");
boolean result = backup.backup_run();
if (result)
System.out.println("备份成功");
}
}
原文链接:http://blog.sina.com.cn/s/blog_59ae45de0100ds17.html