Java???MySQL???????
???????????? ???????[ 2017/2/14 10:42:44 ] ????????Java ???????
????import java.io.BufferedReader;
????import java.io.File;
????import java.io.FileOutputStream;
????import java.io.IOException;
????import java.io.InputStreamReader;
????import java.io.OutputStreamWriter;
????import java.io.PrintWriter;
????/**
????* MySQL???????
????*
????*/
????public class MySQLDatabaseBackup {
????/**
????* Java???????MySQL???????
????*
????* @author GaoHuanjie
????* @param hostIP MySQL?????????????????IP
????* @param userName ?????????????????????
????* @param password ????????????????????
????* @param savePath ??????????????·??
????* @param fileName ???????????????
????* @param databaseName ??????????????
????* @return ????true??????????????????false??
????*/
????public static boolean exportDatabaseTool(String hostIP?? String userName?? String password?? String savePath?? String fileName?? String databaseName) throws InterruptedException {
????File saveFile = new File(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 = new BufferedReader(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;
????}
????public static void main(String[] args){
????try {
????if (exportDatabaseTool("172.16.0.127"?? "root"?? "123456"?? "D:/backupDatabase"?? "2014-10-14.sql"?? "test")) {
????System.out.println("????????????????");
????} else {
????System.out.println("???????????????");
????}
????} catch (InterruptedException e) {
????e.printStackTrace();
????}
????}
????}
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11