java实现mysql数据库的备份和还原

备份：

public class BackUpDataServiceImpl implements BackUpDataService {
    public  void dbBackUp() throws IOException {
        String backPath="D:/backUp/backup.sql";
        String root="root";
        String pwd="root";
        String dbName="数据库名称";
        File fileSql = new File(backPath);
        //创建备份sql文件
        if (!fileSql.exists()){
            fileSql.createNewFile();
        }
        StringBuffer sb = new StringBuffer();
        sb.append("mysqldump");
        sb.append(" -h127.0.0.1");
        sb.append(" -u"+root);
        sb.append(" -p"+pwd);
        sb.append(" "+dbName+" >");
        sb.append(backPath);
        System.out.println("cmd命令为："+sb.toString());
        Runtime runtime = Runtime.getRuntime();
        Process process = runtime.exec("cmd /c"+sb.toString());
        System.out.println("备份成功!");
    }

还原

 public  void dbRestore(){
        String filePath = "D:/supplierBackUp/backup.sql";
        String root="root";
        String pwd="root";
        String dbName="数据库名称";
        StringBuilder sb = new StringBuilder();
        sb.append("mysql");
        sb.append(" -h127.0.0.1");
        sb.append(" -u"+root);
        sb.append(" -p"+pwd);
        sb.append(" "+dbName+" <");
        sb.append(filePath);
        System.out.println("cmd命令为："+sb.toString());
        Runtime runtime = Runtime.getRuntime();
        try {
            Process process = runtime.exec("cmd /c"+sb.toString());
            InputStream is = process.getInputStream();
            BufferedReader bf = new BufferedReader(new InputStreamReader(is,"utf8"));
            String line = null;
            while ((line=bf.readLine())!=null){
                System.out.println(line);
            }
            is.close();
            bf.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
        System.out.println("还原成功！");
    }