日韩一区精品,日韩视频区,男人天堂新地址

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;


//數據庫備份
public class MySQLDump {

	public static boolean sqlDump(String cmd,String filePath){
		boolean falg = false;
		try {
			Runtime run = Runtime.getRuntime();
			//cmd 命令："C:/Program Files/MySQL/MySQL Server 5.1/bin/mysqldump -uroot -proot  email"
			Process p = run.exec(cmd);
			InputStream is = 	p.getInputStream();// 控制臺的輸出信息作為輸入流  
			InputStreamReader isr = new InputStreamReader(is,"UTF-8");//設置輸入流編碼格式
			BufferedReader br = new BufferedReader(isr);
			//將控制臺輸入信息寫入到文件輸出流中
			FileOutputStream fos = new FileOutputStream(filePath);
			BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(fos,"UTF-8"));
			String temp = null;
			while( (temp = br.readLine()) !=null){
				bw.write(temp);
				bw.newLine();
			}
			bw.flush();
			bw.close();
			br.close();
			falg = true;
			System.out.println("/* Dump  SQL File "+filePath+" OK! */");   
		} catch (IOException e) {
			throw new RuntimeException("請將mysql命令添加到path中！",e);
		}
		return falg;
	}
	
	//恢復數據庫
	/**  
     * 導入  
     *  
     */  
    public static void sqlLoad(String cmd,String sqlPath) {   
        try {   
            Runtime rt = Runtime.getRuntime();   
  
            // 調用 mysql 的 cmd: C:/Program Files/MySQL/MySQL Server 5.1/bin/mysql.exe -uroot -proot email  
            Process child = rt.exec(cmd);   
            OutputStream out = child.getOutputStream();//控制臺的輸入信息作為輸出流   
            //輸入流
            BufferedReader br = new BufferedReader(new InputStreamReader(   
                    new FileInputStream(sqlPath), "utf8"));   
            //輸出流
            OutputStreamWriter writer = new OutputStreamWriter(out, "utf8");   
            String inStr;   
            while ((inStr = br.readLine()) != null) {   
                writer.write(inStr);  
                writer.write("\r\n");
            }   
            writer.flush();   
            // 別忘記關閉輸入輸出流   
            out.close();   
            br.close();   
            writer.close();   
            System.out.println("/* Load  SQL File "+sqlPath+" OK! */");   
        } catch (Exception e) {   
            e.printStackTrace();   
        }   
  
    }  
	public static void main(String[] args) {
		sqlDump("C:/Program Files/MySQL/MySQL Server 5.1/bin/mysqldump -uroot -proot  email","c:/email.sql");
		sqlLoad("C:/Program Files/MySQL/MySQL Server 5.1/bin/mysql.exe -uroot -proot email","c:/email.sql");
	}

}

mysql數據庫備份--java代碼

更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索：z360901061

微信掃一掃加我為好友

QQ號聯系： 360901061

您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。

【本文對您有幫助就好】元

2元

5元

10元

20元

自定義

亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频