java备份与还原数据库

最新推荐文章于 2024-08-22 20:16:44 发布

杨家小伙

最新推荐文章于 2024-08-22 20:16:44 发布

阅读量469

点赞数

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

本文链接：https://blog.csdn.net/langwang1993/article/details/84755428

版权

备份数据库

Runtime runtime = Runtime.getRuntime();

Process process = runtime.exec("C:\\Program Files\\MySQL\\MySQL Server 5.5\\bin\\mysqldump -uroot -proot plht");
           InputStream inputStream = process.getInputStream();
           InputStreamReader inputStreamReader = new InputStreamReader(inputStream, "utf-8");
           BufferedReader bufferedReader = new BufferedReader(inputStreamReader);
           StringBuffer sb = new StringBuffer();
           String b = null;
           while((b = bufferedReader.readLine())!=null){
               sb.append(b+"\r\n");
           }
           File file = new File("D:/1.sql");
           FileOutputStream fileOutputStream = new FileOutputStream(file);
           fileOutputStream.write(sb.toString().getBytes());
           inputStream.close();
           bufferedReader.close();
           fileOutputStream.close();
           inputStreamReader.close();

数据库还原

Runtime runtime = Runtime.getRuntime();

Process process = runtime.exec("C:\\Program Files\\MySQL\\MySQL Server 5.5\\bin\\mysql -uroot -proot --default-character-set=utf8 plht");
       OutputStream outputStream = process.getOutputStream();
       BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(new FileInputStream("D:/1.sql")));
       StringBuffer sb = new StringBuffer();
       String b = null;
       while((b = bufferedReader.readLine())!=null){
           sb.append(b+"\r\n");
       }
       OutputStreamWriter outputStreamWriter = new OutputStreamWriter(outputStream,"utf-8");
       outputStreamWriter.write(sb.toString());
       outputStreamWriter.flush();
       outputStreamWriter.close();
       bufferedReader.close();
       outputStream.close();