MySQL Bugs: #46059: option to not fire TRIGGERS

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

This is a duplicate of bug #14661.