linux与win10中java操作mysql备份还原

最新推荐文章于 2021-12-10 14:17:27 发布

海马区

最新推荐文章于 2021-12-10 14:17:27 发布

阅读量215

点赞数

文章标签： java linux mysql 数据库备份还原

本文链接：https://blog.csdn.net/qq_40820382/article/details/109276109

版权

总结：区别有两点，即在于路径和 mysql的执行命令：
1、win10 路径是这样：“E:/hbsqlBack/” ，linux是这样："/usr/local/speedchina/hbsqlBack/"
在win10中，把数据库原始文件放在 “src/main/resources/sql/db.sql"下，后台代码打包成jar后是可以访问的，但是在linux上不能这么做，得这样指定具体的路径：”/usr/local/speedchina/visualizationSystem/db.sql"
2、
在win10 下，.exec()方法里这样写： .exec(“cmd /c”+sb.toString())

// win10 环境
Runtime runtime = Runtime.getRuntime();
Process process = runtime.exec("cmd /c"+sb.toString());

在linux 下，.exec()方法里这样写： .exec({ “/bin/sh”, “-c”, sb.toString() })

// linux 环境
String[] command = { "/bin/sh", "-c", sb.toString() };
Process ps = Runtime.getRuntime().exec(command);

win10 环境备份操作

 private final String DB_NAME = "test_db";

 @PostMapping("/backDB")
    public Map backDB() {
        return mysqlBackService.backDB();
    }

  public Map backDB() {
        HashMap<Object, Object> resultMap = Maps.newHashMapWithExpectedSize(1);
        //获取当前时间用作数据库悲愤sql文件的名称
        String backName = new SimpleDateFormat("yyyy-MM-dd-HH-mm-ss").format(new Date()) + ".sql";
        try {
            String s = BackDBUtiles.dbBackUp(backDBMapper, "127.0.0.1", "root", "123456", DB_NAME, "E:/hbsqlBack/", backName);
            resultMap.put("msg", s);
        } catch (Exception e) {
            resultMap.put("msg", "数据备份失败!");
            e.printStackTrace();
        }
        return resultMap;
    }



    public static String dbBackUp(BackDBMapper backDBMapperStatic, String host,String root,String pwd,String dbName,String backPath,String backName) throws Exception {

            String pathSql = backPath+backName;
            File fileSql = new File(pathSql);
            File fileDir = new File(backPath);

            //如果文件夹不存在
            if(!fileDir.exists()){
                //创建文件夹
                fileDir.mkdir();
            }
            //创建备份sql文件
            if (!fileSql.exists()){
                fileSql.createNewFile();
            }
            //mysqldump -hlocalhost -uroot -p123456 db > /home/back.sql
            StringBuffer sb = new StringBuffer();
            sb.append("mysqldump");
            sb.append(" -h" + host);
            sb.append(" -u"+ root);
            sb.append(" -p"+ pwd);
            sb.append(" "+dbName+" >");
            sb.append(pathSql);
            System.out.println("cmd命令为："+sb.toString());
            // win10 环境
            Runtime runtime = Runtime.getRuntime();
            System.out.println("开始备份："+dbName);
            Process process = runtime.exec("cmd /c"+sb.toString());

            //文件路径添加到数据库
            HashMap<Object, Object> map = new HashMap<>();
            map.put("backSqlPath",pathSql);
            if (backDBMapperStatic.insertBack(map)) {
                System.out.println("备份成功!");
                return "备份成功!";
            }
            return "备份失败";
        }

linux 环境备份操作

 private final String DB_NAME = "test_db";

 @PostMapping("/backDB")
    public Map backDB() {
        return mysqlBackService.backDB();
    }

  public Map backDB() {
        HashMap<Object, Object> resultMap = Maps.newHashMapWithExpectedSize(1);
        //获取当前时间用作数据库备份sql文件的名称
        String backName = new SimpleDateFormat("yyyy-MM-dd-HH-mm-ss").format(new Date()) + ".sql";
        try {
            String s = BackDBUtiles.dbBackUp(backDBMapper, "192.168.12.13", "root", "root", DB_NAME, "/usr/local/test/sqlBack/", backName);
       
            resultMap.put("msg", s);
        } catch (Exception e) {
            resultMap.put("msg", "数据备份失败!");
            e.printStackTrace();
        }
        return resultMap;
    }


   public static String dbBackUp(BackDBMapper backDBMapperStatic, String host,String root,String pwd,String dbName,String backPath,String backName) throws Exception {
            String pathSql = backPath+backName;
            File fileSql = new File(pathSql);
            File fileDir = new File(backPath);
            //如果文件夹不存在
            if(!fileDir.exists()){
                //创建文件夹
                fileDir.mkdir();
            }
            //创建备份sql文件
            if (!fileSql.exists()){
                fileSql.createNewFile();
            }
            //mysqldump -hlocalhost -uroot -p123456 db > /home/back.sql
            StringBuffer sb = new StringBuffer();
            sb.append("mysqldump");
            sb.append(" -h" + host);
            sb.append(" -u"+ root);
            sb.append(" -p"+ pwd);
            sb.append(" "+dbName+" >");
            sb.append(pathSql);
            System.out.println("cmd命令为："+sb.toString());
        
            // linux 环境
             System.out.println("开始备份："+dbName);
            String[] command = { "/bin/sh", "-c", sb.toString() };
             Process ps = Runtime.getRuntime().exec(command);

            
            //文件路径添加到数据库
            HashMap<Object, Object> map = new HashMap<>();
            map.put("backSqlPath",pathSql);
            if (backDBMapperStatic.insertBack(map)) {
                System.out.println("备份成功!");
                return "备份成功!";
            }
            return "备份失败";
        }

win10环境还原操作

 @PostMapping("/initialization")
    public Map initialization() {
        return mysqlBackService.initialization();
    }

    public Map initialization() {
        HashMap<Object, Object> resultMap = Maps.newHashMapWithExpectedSize(1);
        //恢复到初始得数据状态
        String s = BackDBUtiles.dbRestore("127.0.0.1", "root", "123456", DB_NAME, "src/main/resources/sql/db.sql");
        resultMap.put("msg", s);
        return resultMap;
    }

   public static String dbRestore(String host,String root,String pwd,String dbName,String filePath){
            //验证文件名是否是sql文件
            if (filePath.length() < 3) {
                return "请使用正确的.sql文件";
            }
            if (!"sql".equals(filePath.substring(filePath.length() - 3,filePath.length()))){
                return "请使用正确的.sql文件";
            }
            StringBuilder sb = new StringBuilder();
            sb.append("mysql");
            sb.append(" -h"+ host);
            sb.append(" -u"+root);
            sb.append(" -p"+pwd);
            sb.append(" "+dbName+" <");
            sb.append(filePath);
            System.out.println("cmd命令为："+sb.toString());
            // win10 环境 ---------------------
            Runtime runtime = Runtime.getRuntime();
            System.out.println("开始还原数据");
            try {
                // win10 环境   ---------------------
                Process process = runtime.exec("cmd /c"+sb.toString());
              
                System.out.println("输出输出输出---    Runtime.getRuntime().exec(command)");
                InputStream is = process.getInputStream();
                BufferedReader bf = new BufferedReader(new InputStreamReader(is,"utf8"));
                String line = null;
                while ((line=bf.readLine())!=null){
                    System.out.println(line);
                    System.out.println("输出输出输出---    line=bf.readLine())");
                }
                is.close();
                bf.close();
                System.out.println("输出输出输出---    bf.close();");
            } catch (IOException e) {
                e.printStackTrace();
            }
            System.out.println("还原成功！");
            return "还原成功！";
        }

linux环境还原操作

  @PostMapping("/initialization")
    public Map initialization() {
        return mysqlBackService.initialization();
    }

  public Map initialization() {
        HashMap<Object, Object> resultMap = Maps.newHashMapWithExpectedSize(1);
        //恢复到初始得数据状态
        String s = BackDBUtiles.dbRestore("192.168.12.13", "root", "root", DB_NAME, "/usr/local/test/sqlBack/db.sql");
     
        resultMap.put("msg", s);
        return resultMap;
    }

  public static String dbRestore(String host,String root,String pwd,String dbName,String filePath){
            //验证文件名是否是sql文件
            if (filePath.length() < 3) {
                return "请使用正确的.sql文件";
            }
            if (!"sql".equals(filePath.substring(filePath.length() - 3,filePath.length()))){
                return "请使用正确的.sql文件";
            }
            StringBuilder sb = new StringBuilder();
            sb.append("mysql");
            sb.append(" -h"+ host);
            sb.append(" -u"+root);
            sb.append(" -p"+pwd);
            sb.append(" "+dbName+" <");
            sb.append(filePath);
            System.out.println("cmd命令为："+sb.toString());
   
            // linux 环境  ---------------------
            String[] command = { "/bin/sh", "-c", sb.toString() };
            System.out.println("开始还原数据");
            try {
                // linux 环境 ---------------------
                Process process = Runtime.getRuntime().exec(command);
                System.out.println("输出输出输出---    Runtime.getRuntime().exec(command)");
                InputStream is = process.getInputStream();
                BufferedReader bf = new BufferedReader(new InputStreamReader(is,"utf8"));
                String line = null;
                while ((line=bf.readLine())!=null){
                    System.out.println(line);
                    System.out.println("输出输出输出---    line=bf.readLine())");
                }
                is.close();
                bf.close();
                System.out.println("输出输出输出---    bf.close();");
            } catch (IOException e) {
                e.printStackTrace();
            }
            System.out.println("还原成功！");
            return "还原成功！";
        }

总结：区别有两点，即在于路径和 mysql的执行命令：
1、win10 路径是这样：“E:/hbsqlBack/”
linux是这样："/usr/local/speedchina/hbsqlBack/"
在win10中，把数据库原始文件放在 “src/main/resources/sql/db.sql"下，后台代码打包成jar后是可以访问的，但是在linux上不能这么做，得这样指定具体的路径：”/usr/local/speedchina/visualizationSystem/db.sql"
2、
在win10 下，.exec()方法里这样写： .exec(“cmd /c”+sb.toString())

// win10 环境
Runtime runtime = Runtime.getRuntime();
Process process = runtime.exec("cmd /c"+sb.toString());

在linux 下，.exec()方法里这样写： .exec({ “/bin/sh”, “-c”, sb.toString() })

// linux 环境
String[] command = { "/bin/sh", "-c", sb.toString() };
Process ps = Runtime.getRuntime().exec(command);

海马区

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
linux与win10中java操作mysql备份还原

总结：区别有两点，即在于路径和 mysql的执行命令：1、win10 路径是这样：“E:/hbsqlBack/” ，linux是这样："/usr/local/speedchina/hbsqlBack/"在win10中，把数据库原始文件放在 “src/main/resources/sql/db.sql"下，后台代码打包成jar后是可以访问的，但是在linux上不能这么做，得这样指定具体的路径：”/usr/local/speedchina/visualizationSystem/db.sql"2、
复制链接

扫一扫