Saturday 8 June 2013

Mysql DB Backup Using Java

public boolean backupDB( String dbUserName, String dbPassword,String dbName,String path) {

   
  String executeCmd = "mysqldump -u"+dbUserName+ " -p" + dbPassword + " --add-drop-database -B " + dbName + " -r " + path;

       System.out.println(executeCmd);
        Process runtimeProcess;
        try {

      runtimeProcess = Runtime.getRuntime().exec(new String[] { "cmd.exe", "/C", executeCmd });
     
            int processComplete = runtimeProcess.waitFor();

            if (processComplete == 0) {
                System.out.println("Backup created successfully");
                return true;
            } else {
                System.out.println("Could not create the backup");
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        return false;
    }

No comments:

Post a Comment