数据库备份

MySQL数据库备份与还原

package xk;

import java.io.BufferedReader;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.text.SimpleDateFormat;
import java.util.Date;


public class DbOperate {

	/**
	 * 备份数据库db
	 * 
	 * @param root
	 * @param pwd
	 * @param dbName
	 * @param backPath
	 * @param backName
	 */
	public static void dbBackUp(String root, String pwd, String dbName, String backPath, String backName)
			throws Exception {
		String pathSql = backPath + backName;
		File fileSql = new File(pathSql);
		// 创建备份sql文件
		if (!fileSql.exists()) {
			fileSql.createNewFile();
		}
		// mysqldump -hlocalhost -uroot -p123456 db > /home/back.sql
		StringBuffer sb = new StringBuffer();
		sb.append("mysqldump");
		sb.append(" -h127.0.0.1");
		sb.append(" -u" + root);
		sb.append(" -p" + pwd);
		sb.append(" " + dbName + " >");
		sb.append(pathSql);
		System.out.println("cmd命令为：" + sb.toString());
		Runtime runtime = Runtime.getRuntime();
		System.out.println("开始备份：" + dbName);
		Process process = runtime.exec("cmd /c" + sb.toString());
		System.out.println("备份成功!");
	}

	/**
	 * 恢复数据库
	 * 
	 * @param root
	 * @param pwd
	 * @param dbName
	 * @param filePath mysql -hlocalhost -uroot -p123456 db < /home/back.sql
	 */
	public static void dbRestore(String root, String pwd, String dbName, String filePath) {
		StringBuilder sb = new StringBuilder();
		sb.append("mysql");
		sb.append(" -h127.0.0.1");
		sb.append(" -u" + root);
		sb.append(" -p" + pwd);
		sb.append(" " + dbName + " <");
		sb.append(filePath);
		System.out.println("cmd命令为：" + sb.toString());
		Runtime runtime = Runtime.getRuntime();
		System.out.println("开始还原数据");
		try {
			Process process = runtime.exec("cmd /c" + sb.toString());
			InputStream is = process.getInputStream();
			BufferedReader bf = new BufferedReader(new InputStreamReader(is, "utf8"));
			System.out.println("test" + bf.readLine());
			String line = null;
			while ((line = bf.readLine()) != null) {
				System.out.println(line);
			}
			is.close();
			bf.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
		System.out.println("还原成功！");
	}

	public static void main(String[] args) throws Exception {
		String backName = new SimpleDateFormat("yyyy-MM-dd-HH-mm-ss").format(new Date()) + ".sql";
		DbOperate.dbBackUp("root", "123456", "demo", "D:/", backName);
		dbRestore("root", "123456", "db", "D://2019-11-13-17-11-14.sql");
	}

}

oracle数据库备份

package xk;

import java.io.File;
import java.io.IOException;

public class OracleDatabaseBackup {

	/**
	 * Java代码实现Oracle数据库导出
	 * 
	 * @author GaoHuanjie
	 * @param userName 进入数据库所需要的用户名
	 * @param password 进入数据库所需要的密码
	 * @param SID      用户所在的SID
	 * @param savePath 数据库导出文件保存路径
	 * @param fileName 数据库导出文件文件名
	 * @return 返回true表示导出成功，否则返回false。
	 */
	public static boolean exportDatabaseTool(String userName, String password, String SID, String savePath,
			String fileName) throws InterruptedException {
		File saveFile = new File(savePath);
		if (!saveFile.exists()) {// 如果目录不存在
			saveFile.mkdirs();// 创建文件夹
		}
		try {

			Process process = Runtime.getRuntime().exec(
					"exp " + userName + "/" + password + "@" + SID + " file=" + savePath + "/" + fileName + ".dmp");

			if (process.waitFor() == 0) {// 0 表示线程正常终止。
				return true;
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
		return false;
	}

	public static void main(String[] args) throws InterruptedException {
		if (exportDatabaseTool("dm", "dmdm", "orcl", "d:/BackupDatabase", "oracledb")) {
			System.out.println("数据库成功备份！！！");
		} else {
			System.out.println("数据库备份失败！！！");
		}
	}
}