Link to home
Start Free TrialLog in
Avatar of Omer-Pitou
Omer-Pitou

asked on

MySqlDump not dumping triggers

Dear sirs,
What can be the reason for MySQL not to dump triggers with the following code
String cmd = serverpath + "mysqldump "
                        + " --user=" + dbsetting.getDbUser()
                        + " --password=" + dbsetting.getDbPassword()
                        + " --host=" + dbsetting.getHost()
                        + " --port=" + dbsetting.getPort()
                        + " --protocol=tcp "
                        + " --add-drop-database "
                        + " --triggers "
                        + " --routines "
                        + " --events "
                        + " --single-transaction " //?????
                        + " --default-character-set=utf8 "
                        + " --databases " + dbsetting.getDbName()
                        + " -r " + filepath;

                Process runtimeProcess;

                runtimeProcess = Runtime.getRuntime().exec(cmd);
                int processComplete = runtimeProcess.waitFor();
                if (processComplete == 0) {
ASKER CERTIFIED SOLUTION
Avatar of Omer-Pitou
Omer-Pitou

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial