Drop all MySQL triggers in just one go

Posted by – January 9, 2009

  1. Locate the path of datadir from /etc/my.cnf.
  2. Go to datadir/databasename folder
  3. Delete all .trg files
  4. Done! B-)

1 Comment on Drop all MySQL triggers in just one go

  1. Herp says:

    The triggers still exist somewhere. If you do this and try to create a new trigger with an old name you’ll get an error stating that the trigger already exists, despite show triggers returning no results.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>