Skip to content

Instantly share code, notes, and snippets.

@carlosspohr

carlosspohr/dump-triggers.sql

Created August 23, 2018 13:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save carlosspohr/0f4039af4661d9ebaa8eb04a1360b2f1 to your computer and use it in GitHub Desktop.
Save carlosspohr/0f4039af4661d9ebaa8eb04a1360b2f1 to your computer and use it in GitHub Desktop.
Download ZIP
How to dump only triggers and procedures/functions without table structure and data.
Raw
dump-triggers.sql
mysqldump -u root -p --no-data --routines --triggers -t your-database > triggers.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment