完整备份MySQL的某个数据库

package com.manze.stu;
import java.io.BufferedReader;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
public class BackupMysqlDb {


	/**
	  * www.itlife365.com 
	  * 完整备份MySQL的某个数据库
	  * mysqldump –h hostname –u username –p password databasename > backupfile.sql
	  * 例如：将192.168.102.2服务器上的book数据库备份到192.168.102.3
	  * mysqldump -h 192.168.102.2 -u backup -p book >book.sql

	  * @author happymen001
	  * @version Jun 16, 2010  11:11:25 AM
	  * @param hostName
	  * @param dataBase
	  * @param userName
	  * @param passwd
	  * @param outFilePath
	  * @throws Exception
	  * @return void
	  */
	public static void backupMysqlDatabase(String hostName,String dataBase,String userName,
	    String passwd,String outFilePath )throws Exception {
	  //组装MySQL的备份命令
	  StringBuilder sqlStr = new StringBuilder();
	  sqlStr.append("C:/Program Files/MySQL/MySQL Server 5.0/bin/mysqldump -u").append(userName)
	     
	     .append(" -p").append(passwd)
	     .append(" ").append(dataBase);
	  if(hostName != null && !hostName.equals("") ){
	   sqlStr.append(" ")
	         .append(" -h").append(hostName);
	  }
	  // --default-character-set=gb2312 
	  //调用系统cmd 命令执行备份命令
	  Runtime rt = Runtime.getRuntime();
	  Process process = rt.exec(sqlStr.toString());
	  InputStream in = process.getInputStream();//控制台的输出信息作为输入流
	  InputStreamReader isr = new InputStreamReader(in,"utf8");
	  
	  StringBuilder sb = new StringBuilder("");
	  String inStr;
	  //组合控制台输出信息字符串
	  BufferedReader br = new BufferedReader(isr);
	  while((inStr = br.readLine()) != null){
	   sb.append(inStr)
	    .append("\r\n");
	  }
	  
	  //把备份数据写入到文件中
	  FileOutputStream fout = new FileOutputStream (outFilePath);
	  OutputStreamWriter writer = new OutputStreamWriter(fout,"utf8");
	  writer.write(sb.toString());
	  writer.flush();
	  //写完文件，关闭相应的流
	  in.close();
	  isr.close();
	  br.close();
	  writer.close();
	  fout.close();
	}
	   
	/**
	  * @author happymen001
	  * @version Jun 15, 2010  11:26:46 PM
	  * @param args
	  * @return void
	  */
	public static void main(String[] args) {
	  // TODO Auto-generated method stub
	  BackupMysqlDb  backupMysqlDb = new BackupMysqlDb ();
	  String hostName = "192.168.26.200";
	  String dataBase = "ec";//is
	  String userName = "root";
	  String passwd = "bjbjbj";
	  String outFilePath = "D:\\backupmysql.sql";
	  
	  try {
	   backupMysqlDb.backupMysqlDatabase(hostName,dataBase, userName, passwd, outFilePath);
	  } catch (Exception e) {
	   // TODO Auto-generated catch block
	   e.printStackTrace();
	   System.out.println(" 备份MySQL失败");
	  }
	  System.out.println(" 备份MySQL 成功");
	}

	}