用Java代码备份和还原MySQL数据库详解编程语言

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后面是用户名，-p是密码-p后面最好不要有空格，-family是数据库的名字 
		Process process = runtime.exec("mysqldump -u root -p123456 family"); 
		InputStream inputStream = process.getInputStream();//得到输入流，写成.sql文件 
		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后面是用户名，-p是密码-p后面最好不要有空格，-family是数据库的名字，--default-character-set=utf8，这句话一定的加 
		//我就是因为这句话没加导致程序运行成功，但是数据库里面的内容还是以前的内容，最好写上完成的sql放到cmd中一运行才知道报错了 
		//错误信息： 
		//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/)， 
		//又是讨人厌的编码问题，在恢复的时候设置一下默认的编码就可以了。 
		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(); 
	} 
}