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=ut f8 "
+ " --databases " + dbsetting.getDbName()
+ " -r " + filepath;
Process runtimeProcess;
runtimeProcess = Runtime.getRuntime().exec( cmd);
int processComplete = runtimeProcess.waitFor();
if (processComplete == 0) {
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=ut
+ " --databases " + dbsetting.getDbName()
+ " -r " + filepath;
Process runtimeProcess;
runtimeProcess = Runtime.getRuntime().exec(
int processComplete = runtimeProcess.waitFor();
if (processComplete == 0) {
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.