MySQL Trigger not Visisble

Posted on 2013-09-17
Medium Priority
Last Modified: 2013-09-18
I am using MySQL workbench 6.0 and have created a trigger but when i go to teh alter table command it is not visible.

All the other triggers are visible, any reason why this is not.

Need to change the statement, any way I can script it or make it visible for editing.
Question by:Brogrim
  • 3
  • 2
LVL 17

Expert Comment

ID: 39502296
Is the trigger actually working?

Is it possible it didn't save?

I have accidentally copied triggers from one table to another and only changed the Trigger table name, and forgot to change it in the Trigger Event table name, so when you save it, it gets put on the other table... Appears to be missing, but it is just under the wrong table.

Author Comment

ID: 39502577
I have checked the trigger table event name, I dropped the trigger and created it again and it still does'nt display.

It is firing on that table so very confusing. I have used SHOW TRIGGERS and it is returned in the trigger list with all the other triggers that are been displayed correctly.
LVL 17

Expert Comment

ID: 39502758
Are you creating the trigger with a script or through the table editor.  There was a bug in a previous version that was fixed that is pretty much this exact issue if you are creating the trigger outside of workbench.

it's possible that it is just a bug again in the new version of workbench. Out of curiosity do you have an older version of workbench on another machine you could use to see if the trigger appears in that. If it does, I would report it as a bug on bugs.mysql.com

Author Comment

ID: 39502871
I have MySQL Worbench CE 5.02 installed on the server and the latest workbench 6.0 on my desktop.

Worbench CE 5.02 is displaying the trigger but still no sign of it on my desktop workbench 6.0
LVL 17

Accepted Solution

jrm213jrm213 earned 2000 total points
ID: 39502883
I would report it as a bug and let them resolve it. If it displays in 5.02 and not in 6.0 then it sounds like a software issue.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question