java项目如何实现数据恢复_Java web 项目中对数据库备份和恢复

说白了，还是去调用cmd实现数据库的备份和还原功能。

备份：

mysqldump -hserverUrl -uusername -ppassword dbname > savePath

还原：

mysql -hserverUrl -uusername -ppassword dbname < filePath

package com.cxx.backupdb;

import java.io.*;

import java.text.SimpleDateFormat;

import java.util.Date;

/**

* @Author: cxx

* 数据库备份与还原

* @Date: 2018/4/28 19:56

*/

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(" -h60.115.212.196");

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(" -h60.115.212.196");

sb.append(" -u"+root);

sb.append(" -p"+pwd);

sb.append(" "+dbName+"