I have no permission to take dump from live server.. More than 30 triggers here, I want update definer name without Recreating Triggers.
Is it possible?
Asked
Active
Viewed 2,352 times
0
Z.I.J
- 1,137
- 15
- 35
-
1Unfortunately, there is no ALTER TRIGGER statement in MySQL. DROP/CREATE is only way. – Devart Feb 10 '17 at 07:52
-
look at this http://stackoverflow.com/questions/18593746/how-to-bulk-change-mysql-triggers-definer its may be helps. – Sagar Gangwal Feb 10 '17 at 07:54
-
@SagarGangwal I want to change or update triggers without recreating. – Z.I.J Feb 10 '17 at 07:56