title: Importing mysql database from java code
body: <p><strong>This code do restore mysql tables but application almost goes into sleep(20min plus). and my database Routines do not come in mysql workbench, can somebody tell me what is the actual solution?</strong></p>
  
  <pre><code>public static boolean restoreDB(String dbName, String dbUserName, String dbPassword, String source) {
  
      String[] executeCmd = new String[]{"C:\\Program Files\\MySQL\\MySQL Server 5.5\\bin\\mysql", "--user=" + dbUserName, "--password=" + dbPassword, "-e", "source \"D:/khokher/mydb.sql\""};
  
      Process runtimeProcess;
      try {
  
          runtimeProcess = Runtime.getRuntime().exec(executeCmd);
          int processComplete = runtimeProcess.waitFor();
  
          if (processComplete == 0) {
              System.out.println("Backup restored successfully");
              return true;
          } else {
              System.out.println("Could not restore the backup");
          }
      } catch (Exception ex) {
          ex.printStackTrace();
      }
  
      return false;
  }
  </code></pre>