mysql完全备份_mysql 完全备份

//mysql 完全备份实现类

package com.sky.mysql;

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.io.OutputStream;

import java.util.Properties;

public class MySqlBackup {

public void backup() throws IOException {

Properties pros = new BackupUtil().getPprVue("pro.properties");// 读取db文件

String username = pros.getProperty("username");//用户名

String password = pros.getProperty("password");//密码

String dataName=pros.getProperty("dataName");//数据库

String address = pros.getProperty("address");//ip地址

//C:\Program Files\MySQL\MySQL Server 5.0\bin

String mysqldump="C:\\Program Files\\MySQL\\MySQL Server 5.0\\bin\\mysqldump";//mysql安装目录

String savePath = pros.getProperty("savePath");//保存的路径

StringBuffer sb = new StringBuffer();

sb.append(mysqldump);

sb.append(" -u ");

sb.append(username);

sb.append(" ");

sb.append("-p");

sb.append(password+" ");

sb.append(dataName);

sb.append(" ");

sb.append("-h ");

sb.append(address);

System.out.println("\n\t");

try {

Runtime rt = Runtime.getRuntime();

Process process = rt.exec(sb.toString());// 执行命令

InputStream in = process.getInputStream();// 控制台的输出信息作为输入流

InputStreamReader inputRead = new InputStreamReader(in, "utf8");// 设置输出流编码为utf8

File backupath = new File(savePath);

if (!backupath.exists()) {

backupath.mkdir();

}

String sqlname=new BackupUtil().getTime();//文件名

String filePath = savePath+File.separator + sqlname;//文件路径

OutputStream outputStream = new FileOutputStream(filePath);

byte[] buff = new byte[512];

int len;

while ((len = in.read(buff)) != -1) {

outputStream.write(buff, 0, len);

}

in.close();

inputRead.close();

outputStream.close();

} catch (Exception e) {

e.printStackTrace();

}

System.out.println("\n\t");

}

public static void main(String[] args) throws IOException {

new MySqlBackup().backup();//数据库备份

}

}

//mysql 完全备份工具类

package com.sky.mysql;

import java.io.IOException;

import java.io.InputStream;

import java.text.SimpleDateFormat;

import java.util.Date;

import java.util.Properties;

public class BackupUtil {

public Properties getPprVue(String string) {

//  BackmysqlUtil.class.getClassLoader().getResourceAsStream(string);

InputStream input=BackupUtil.class.getClassLoader().getResourceAsStream(string);

Properties pro=new Properties();

try {

pro.load(input);

} catch (IOException e) {

e.printStackTrace();

}

return pro;

}

public String getTime(){

Date d = new Date();

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hhmmss");

String s =sdf.format(d);

return s;

}

}

//mysql 完全备份properties文件

username=root

password=1

address=127.0.0.1

savePath=e:\\backup

dataName=pkb

下载次数: 2

分享到：

2011-10-20 17:42

浏览 1021

评论