=== modified file 'client/mysqldump.c' --- client/mysqldump.c 2010-01-27 15:13:39 +0000 +++ client/mysqldump.c 2010-06-08 11:52:29 +0000 @@ -2754,6 +2754,9 @@ if (opt_compact) fprintf(sql_file, "/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;\n"); + if (opt_drop) + fprintf(sql_file, "/*!50032 DROP TRIGGER IF EXISTS %s */;\n", (*show_trigger_row)[0]); + fprintf(sql_file, "DELIMITER ;;\n" "/*!50003 SET SESSION SQL_MODE=\"%s\" */;;\n" @@ -2828,6 +2831,9 @@ switch_sql_mode(sql_file, ";", row[1]); + if (opt_drop) + fprintf(sql_file, "/*!50032 DROP TRIGGER IF EXISTS %s */;\n", row[0]); + fprintf(sql_file, "DELIMITER ;;\n" "/*!50003 %s */;;\n"