MySQL Forums
Forum List  »  MySQL Workbench

Export Trigger DDL from Workbench and related issue
Posted by: Chen-Hsiao Shih
Date: June 02, 2008 12:29PM


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!

Options: ReplyQuote

Written By
Export Trigger DDL from Workbench and related issue
June 02, 2008 12:29PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.