java mysql备份与恢复_JAVA实现MySQL数据库备份及恢复

packagecom.xxx.core.db;import java.io.*;/*** @Auther: ErDong

* @Date: 2019/10/28 0028 08:50

* @Description:*/

public classMySQLDatabaseBackup {/*** Java代码实现MySQL数据库导出

*

*@authorErDong

*@paramhostIP MySQL数据库所在服务器地址IP

*@paramuserName 进入数据库所需要的用户名

*@parampassword 进入数据库所需要的密码

*@paramsavePath 数据库导出文件保存路径

*@paramfileName 数据库导出文件文件名

*@paramdatabaseName 要导出的数据库名

*@return返回true表示导出成功，否则返回false。*/

public static boolean exportDatabase(String hostIP, String userName, String password, String savePath, String fileName, String databaseName) throwsInterruptedException {

File saveFile= newFile(savePath);if (!saveFile.exists()) {//如果目录不存在

saveFile.mkdirs();//创建文件夹

}if(!savePath.endsWith(File.separator)){

savePath= savePath +File.separator;

}

PrintWriter printWriter= null;

BufferedReader bufferedReader= null;try{

printWriter= new PrintWriter(new OutputStreamWriter(new FileOutputStream(savePath + fileName), "utf8"));

Process process= Runtime.getRuntime().exec(" mysqldump -h" + hostIP + " -u" + userName + " -p" + password + " --set-charset=UTF8 " +databaseName);

InputStreamReader inputStreamReader= new InputStreamReader(process.getInputStream(), "utf8");

bufferedReader= newBufferedReader(inputStreamReader);

String line;while((line = bufferedReader.readLine())!= null){

printWriter.println(line);

}

printWriter.flush();if(process.waitFor() == 0){//0 表示线程正常终止。

return true;

}

}catch(IOException e) {

e.printStackTrace();

}finally{try{if (bufferedReader != null) {

bufferedReader.close();

}if (printWriter != null) {

printWriter.close();

}

}catch(IOException e) {

e.printStackTrace();

}

}return false;

}/*** 导入Mysql数据库

*@paramhostIP 数据库地址

*@paramhostPort 端口

*@paramuserName 用户名

*@parampassword 密码

*@paramimportFilePath 数据库文件路径

*@paramsqlFileName 要导入的文件名

*@paramdatabaseName 要导入的数据库名

*@return*@throwsInterruptedException*/

public static booleanimportDatabase(String hostIP, String hostPort, String userName, String password, String importFilePath, String sqlFileName, String databaseName) {

File imporFile= newFile(importFilePath);if (!imporFile.exists()) {

imporFile.mkdirs();

}if (!importFilePath.endsWith(File.separator)) {

importFilePath= importFilePath +File.separator;

}try{//创建数据库：mysqladmin -h 192.168.1.40 -u root -proot create icqr

String createDB = "mysqladmin -h " + hostIP + " -u " + userName + " -p" + password + " create " +databaseName;

Runtime.getRuntime().exec(createDB);//写入数据：mysql -h127.0.0.1 -uroot -P3306 -p test

Process process = Runtime.getRuntime().exec("cmd /C" + "mysql -h" + hostIP+" -P" + hostPort + " -u" + userName + " -p" + password + " " + databaseName + "

}

}catch(IOException e) {

e.printStackTrace();

}catch(InterruptedException e){

e.printStackTrace();

}return false;

}public static voidmain(String[] args){

Boolean result= true;//result = importDatabase("127.0.0.1", "3306", "root", "password", "D:\\backupDatabase", "2014-10-14.sql", "databaseName");

try{

result= exportDatabase("127.0.0.1", "root", "password", "D:\\backupDatabase\\"," backup.sql", "databaseName");

}catch(Exception e) {

e.printStackTrace();

}if(result) {

System.out.println("数据库备份成功");

}else{

System.out.println("数据库备份失败！！！");

}

}

}