Solved

Triggers not available through MySQL Administrator

Posted on 2008-11-02
3
770 Views
Last Modified: 2012-05-05
I am using MySQL 5.1 Community Server. I have installed MySQL Administrator 1.2.12. The GUI Front-end is not showing anything to create and work with triggers. Why?
0
Comment
Question by:rpkhare
3 Comments
 
LVL 16

Accepted Solution

by:
Gyanendra Singh earned 65 total points
Comment Utility
no its not available with MySQL Administrator

try SQLyog ...  

for viewing the trigger try selecting from information_schema.triggers
0
 
LVL 26

Assisted Solution

by:ushastry
ushastry earned 60 total points
Comment Utility
Agree with BondingASP... You can try SQLYog or even MySQL Query browser which is shipped with MySQl Gui tools...  write triggers in sql script and load it/execute it thru Query Browser.. make sure you add drop trgger at the top.. so that next time if you load the same sql script yo won't see any errors.
0
 
LVL 8

Author Closing Comment

by:rpkhare
Comment Utility
Thanks
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Creating and Managing Databases with phpMyAdmin in cPanel.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

728 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now