Java对MySql数据库进行备份与还原

数据库的备份与还原对项目而言是无疑是对安全考虑的好方法，MySQL 数据库备份原理： Navicat等数据库界面软件通用的数据库备份原理就是直接调用MYSQL本身的系统命令。
那么Java是如何来实现备份与还原mysql的呢：这里JavaApi里面给出了Runtime.getRuntime().exe("")方法，它可以执行系统目录下bin下的cmd命令比如windows下的
mysql.exe或者linux下的mysql/bin/mysql命令
MySql数据库备份

    public static String comman="C:/Program Files/MySQL/MySQL Server 5.5/bin/mysql.exe -uroot -proot test";
    public static void back(String mySqlBackupName,String mysqlBackupPath, String command){
        
        String fPath=mysqlBackupPath+"/"+new Date().getTime()+".sql";
        
        Runtime rt = Runtime.getRuntime();
        try {
            Process child = rt.exec(command);
            InputStream in = child.getInputStream();
            InputStreamReader input = new InputStreamReader(in,"utf8");
            
            String inStr;
            StringBuffer sb = new StringBuffer("");
            String outStr;
            
            BufferedReader br = new BufferedReader(input);
            while ((inStr = br.readLine()) != null) {     
                sb.append(inStr + "\r\n");     
            }     
            outStr = sb.toString(); 
            
            FileOutputStream fout = new FileOutputStream(fPath);
            OutputStreamWriter writer = new OutputStreamWriter(fout, "utf8");    
            writer.write(outStr);
            writer.flush();   
            
            in.close();     
            input.close();     
            br.close();     
            writer.close();     
            fout.close();     
            
            logger.info("MYSQL备份成功");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

MySql数据库备份(这里用Servlet实现)

    private static final Logger logger = Logger.getLogger(CBSDAddServlet.class);
    public static String fPath="D:/apache-tomcat-6.0.30/webapps/test/databaseSql/2014-04-15.sql";
    public static String comman=" C:/Program Files/MySQL/MySQL Server 5.5/bin/mysql -uroot -proot --default-character-set=utf8 test ";
       
    private static final long serialVersionUID = -3323607254010948405L;

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        doPost(request, response);
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {

        boolean flag=false;
        try {
            /***
             * 关闭当前项目与数据库的连接
             * 这里很重要，如果是hibernate等连接池的session与数据库保持连接的话,因为还原会直接覆盖当前的数据库
             * 而覆盖之前当前的session与数据库保持了一份连接，所以点击备份时会直至卡在那里...这里得 关闭closeSession();操作
             * ***/
            BaseDao.closeSession(new BaseDao().getSession());
            hy(request, response);
            flag = true;
            logger.info("还原成功");
        } catch (Exception e) {
            e.printStackTrace();
            logger.info("开始失败...");
        }
        
        response.setCharacterEncoding("UTF-8");
        response.getWriter().print(flag);
    }


    public void hy(HttpServletRequest request, HttpServletResponse response) throws IOException{
        Runtime rt = Runtime.getRuntime(); 
        Process child = rt.exec(comman);

        InputStreamReader in =new InputStreamReader(new FileInputStream(fPath),"UTF-8");
        BufferedReader br =new BufferedReader(in);
      
        String inStr =null;
        StringBuffer sb = new StringBuffer("");
        String outStr;
        while((inStr=br.readLine())!=null){
             sb.append(inStr + "\r\n"); 
        }
        outStr = sb.toString();
        
        logger.info(outStr);

        OutputStream out = child.getOutputStream();
        OutputStreamWriter writer =new OutputStreamWriter(out,"UTF-8");
        writer.write(outStr);
        writer.flush();
        
        out.flush();
        out.close();     
        br.close();     
        writer.close();  
        logger.info("数据回复成功！");
    }

还原成功...
参考博客:
http://blog.csdn.net/hguisu/article/details/7325124
http://www.blogjava.net/Nirvana/archive/2012/09/07/387226.html
http://blog.csdn.net/djl100/article/details/9000409