Bug #46059 option to not fire TRIGGERS
Submitted: 8 Jul 2009 20:50 Modified: 9 Jul 2009 7:21
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0+ OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[8 Jul 2009 20:50] Peter Laursen
Description:
Sometimes when you do database maintanaince you do not want TRIGGERS to fire and will have to manually revert what changes to tables was done by triggers. It can be very tedious.

There should be an option 

1) to SET TRIGGERS ON|OFF for a SESSION

and/or

2) to SET TRIGGERS ON|OFF for specific users (in the TRIGGER definition)

How to repeat:
see above

Suggested fix:
see above
[9 Jul 2009 7:21] Valeriy Kravchuk
This is a duplicate of bug #14661.