Menu

#1403 (ok 4.2) Export for triggers only

Next_release
fixed
None
1
2014-05-21
2013-01-30
No

I'd like to request another option on the custom export method form to allow for exporting just the trigger code from the database. As it stands now, custom scripts must be created to parse all the CREATE TRIGGER sections of code out of an export (or manually exporting the triggers one at a time in the Triggers tab of the interface).

Since one can't enable/disable triggers in mySQL, this would make it easier to construct drop/create scripts for all triggers when doing data imports, etc.

I think that mysqldump can do this via the -triggers option, but I'd prefer to use this tool for all my mySQL needs!

Discussion

  • Marc Delisle

    Marc Delisle - 2014-02-06
    • assigned_to: Chanaka Indrajith Dharmarathna
     
  • Marc Delisle

    Marc Delisle - 2014-02-07
    • summary: Export for triggers only --> (ok 4.2) Export for triggers only
    • status: open --> resolved
    • Group: Needs_decision --> Next_release
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2014-05-21
    • Status: resolved --> fixed
     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.