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

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): Cant // 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();

10145.html

cjavamysqlxml