mysql restore hangs forever [Solved] (Java in General forum at Coderanch)

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

精明的白开水 · MySQL插入循环存储过程问题：最后一行重复 ...· 2 周前 ·

读研的冲锋衣 · MySQL循环插入日期递增数据报错：语法问题 ...· 2 周前 ·

一身肌肉的打火机 · MySQL中TIMESTAMP因2038年问 ...· 6 天前 ·

私奔的绿豆 · 8c ...· 2 天前 ·

傻傻的凳子 · MySQL ...· 2 天前 ·

慷慨大方的皮带 · 在Razor Page ...· 1 年前 ·

跑龙套的沙滩裤 · python 使用shutil.copy ...· 1 年前 ·

年轻有为的回锅肉 · spring-boot-jpa ...· 2 年前 ·

傻傻的刺猬 · 【最佳实践】如何限制用户仅通过HTTPS方式 ...· 2 年前 ·

Hello,

I'm trying to restore data using mysql command.

Here is the code to take backup.

And finally here is the code for restore

public void restore(String filePath) {
        String dbUserName = "root";
        String dbPassword = "root";
        String dbName = "agent";
        String executeCmd = "mysql -u" + dbUserName + " -p" + dbPassword + " " + dbName + " " + filePath;
        Process runtimeProcess;
        try {
            runtimeProcess = Runtime.getRuntime().exec(executeCmd);
            BufferedReader in = new BufferedReader(new InputStreamReader(runtimeProcess.getErrorStream()));
            String line = null;
            while ((line = in.readLine()) != null) {
                System.out.println(line);
            BufferedReader inOne = new BufferedReader(new InputStreamReader(runtimeProcess.getInputStream()));
            String lineOne = null;
            while ((lineOne = inOne.readLine()) != null) {
                System.out.println(lineOne);
            int processComplete = runtimeProcess.waitFor();
            if (processComplete == 0) {
                System.out.println("Backup restored successfully");
            } else {
                System.out.println("Could not restore the backup");
        } catch (Exception ex) {
            ex.printStackTrace();

Backup works perfect but restore hangs for ever....

Tried the same mysql command with < in command prompt which is working fine. But could not make it to work in Java . And in the logs there is no error or warning.

Please help me in this.

Regards,
Kiran

You have the classic deadlock associated with Runtime.exec() and ProcessBuilder. You are waiting for the process to complete but it can't complete because either the process stdout or stderr buffer becomes full. The process then suspends until there is room in the buffer to place more output but since you do not process either the stdout or stderr to make more room available until the process completes you have a deadlock.

You need to read ALL the sections of http://www.javaworld.com/article/2071275/core-java/when-runtime-exec---won-t.html and implement ALL the recommendations.

You showed up just in time for the waffles! And this tiny ad:

The Low Tech Laboratory Movie Kickstarter is LIVE NOW!

https://www.kickstarter.com/projects/paulwheaton/low-tech contact us | advertise |

推荐文章

精明的白开水 · MySQL插入循环存储过程问题：最后一行重复插入如何解决？

2 周前

读研的冲锋衣 · MySQL循环插入日期递增数据报错：语法问题排查求助

2 周前

一身肌肉的打火机 · MySQL中TIMESTAMP因2038年问题报错及DATETIME替代方案-云数据库 RDS-阿里云

6 天前

私奔的绿豆 · 8c 数据库，MySQL数据库5.8以上与以下版本，Oracle数据库实现row_number() over(partition by 分组列 order by 排序列 desc)开发者社区-

2 天前

傻傻的凳子 · MySQL 单表数据最大不要超过多少行？为什么？ - Lafite-1820

2 天前

慷慨大方的皮带 · 在Razor Page Linq中动态创建WHERE子句_Linq to Entities中的动态where子句_如何在where子句中创建动态linq xml？ - 腾讯云开发者社区 - 腾讯云

1 年前

跑龙套的沙滩裤 · python 使用shutil.copy 进行目录copy时报错IOError: [Errno 13] Permission denied - OSCHINA - 中文开源技术交流社区

1 年前

年轻有为的回锅肉 · spring-boot-jpa 自定义查询工具类 - 小小小小小小鱼 - 博客园

2 年前

傻傻的刺猬 · 【最佳实践】如何限制用户仅通过HTTPS方式访问OSS？-阿里云开发者社区

2 年前