Export Trigger DDL from Workbench and related issue

[Chen-Hsiao Shih]

Hi,

I am having a problem in exporting Trigger DDL from Workbench. Two triggers are defined for one of my table but none of them are able to export. I have to do copy&paste to another text editor. When I have in my export window is as following:

1. None of SQL option is selected
2. Speicified a output file
3. Object of type MySQL Trigger is the only object to export
4. In Detailed Selection, there are three items. Besides my two triggers, the other one indicates syntax error. The error object is ON the EXCLUSION list.

The export file is empty beside 6-line codes for initializing/reverting environment. However, all the trigger codes are proven to work; ie, I maunually copied/pasted them onto MySQL Client window without any syntax errors and both worked perfect for my purpose.

I had similar experience with this kind of error objects in routine editor. At that time, a error oejct wouldn't go away during exporting no matter what I did, even after removed the whole routine group, created a new one and pasted error-free codes. Finally, I found the error object existed in the Routines category under MySQL Model and removed it successfully.

However, I had the same problem with Trigger now. But, is there any similar way to remove the error object? I suspect it prohibits me from exporting trigger script. Thanks in advance!