bitscn.com
import java.io.ioexception;
import java.text.simpledateformat;
import java.util.date;
public class backupmysql {
 /** 访问mysql数据库服务器所在的url */
 private string serverurl;
 /** 访问mysql数据库的用户名 */
 private string username;
 /** 访问mysql数据库的密码 */
 private string password;
public string getserverurl() {
  return serverurl;
 }
 public void setserverurl(string serverurl) {
  this.serverurl = serverurl;
 }
 public string getusername() {
  return username;
 }
 public void setusername(string username) {
  this.username = username;
 }
 public string getpassword() {
  return password;
 }
 public void setpassword(string password) {
  this.password = password;
 }
 public backupmysql(string serverurl,string username, string password) {
  super();
  this.serverurl=serverurl;
  this.username = username;
  this.password = password;
 }
 public string backup(string backuppath, string dbname) throws ioexception {
  string backupfile = backuppath+ dbname+ new simpledateformat(yyyy-mm-dd-hh-mm-ss).format(new date()) + .sql;
  string mysql = mysqldump +--host=+serverurl+ --user= + username + --password=+ password + --opt + dbname + > + backupfile;
  java.lang.runtime.getruntime().exec(cmd /c + mysql);
system.out.println(备份成功!);
return backupfile;
 }
 public void restore(string restorefile, string dbname) throws exception {
string mysql = mysql +-h+serverurl+ -u + username + -p+ password + + dbname +  
        system.out.println(mysql);
java.lang.runtime.getruntime().exec(cmd /c + mysql);
system.out.println(还原成功!);
 }
 /**
  * @param args
  */
 public static void main(string[] args) {
  string serverurl=127.0.0.1;
string username = root;
  string pwd = root;
  backupmysql backup = new backupmysql(serverurl,username, pwd);
  try {
   backup.restore(d:/nationz2010-12-20-14-16-47.sql, nationz);
  } catch (exception e) {
   e.printstacktrace();
  }
 }
}
摘自 gdn_wolf的专栏
bitscn.com