Implementation code for restoring mysql database through java backup

Copy the code code as follows:

import java.io.BufferedReader;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.io.OutputStream;

import java.io.OutputStreamWriter;

public class Test {

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

backup("d:////d.sql");

recover("d:////d.sql");

}

public static void backup(String path) throws IOException{

Runtime runtime = Runtime.getRuntime();

//-u is followed by the user name, -p is the password, it is best not to have spaces after -p, -family is the name of the database

Process process = runtime.exec("mysqldump -u root -p123456 family");

InputStream inputStream = process.getInputStream();//Get the input stream and write it as a .sql file

InputStreamReader reader = new InputStreamReader(inputStream);

BufferedReader br = new BufferedReader(reader);

String s = null;

StringBuffer sb = new StringBuffer();

while((s = br.readLine()) != null){

sb.append(s+"//r//n");

}

s = sb.toString();

System.out.println(s);

File file = new File(path);

file.getParentFile().mkdirs();

FileOutputStream fileOutputStream = new FileOutputStream(file);

fileOutputStream.write(s.getBytes());

fileOutputStream.close();

br.close();

reader.close();

inputStream.close();

}

public static void recover(String path) throws IOException{

Runtime runtime = Runtime.getRuntime();

//-u is followed by the user name, -p is the password, it is best not to have spaces after -p, -family is the name of the database, --default-character-set=utf8, this sentence must be added

//It is because I did not add this sentence that the program ran successfully, but the content in the database is still the previous content. It is best to write the completed sql and put it in cmd to run it before you know that the error is reported.

//error message:

//mysql: Character set 'utf-8' is not a compiled character set and is not specified in the '

//C://Program Files//MySQL//MySQL Server 5.5//share//charsets//Index.xml' file ERROR 2019 (HY000): Can't

// initialize character set utf-8 (path: C://Program Files//MySQL//MySQL Server 5.5//share//charsets//),

//Another annoying encoding problem, just set the default encoding when restoring.

Process process = runtime.exec("mysql -u root -p123456 --default-character-set=utf8 family");

OutputStream outputStream = process.getOutputStream();

BufferedReader br = new BufferedReader(new InputStreamReader(new FileInputStream(path)));

String str = null;

StringBuffer sb = new StringBuffer();

while((str = br.readLine()) != null){

sb.append(str+"//r//n");

}

str = sb.toString();

System.out.println(str);

OutputStreamWriter writer = new OutputStreamWriter(outputStream,"utf-8");

writer.write(str);

writer.flush();

outputStream.close();

br.close();

writer.close();

}

}