java 自动备份MySQL 数据库(转载)

 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

上一篇:MyEclipse部署项目到Tomcat上,但是classes文件夹下没有编译项目


下一篇:ABP中使用Redis Cache(1)