Security in MySQL :: 5 Backup and Recovery :: 5.4 Using mysqldump for Backups :: 5.4.5 mysqldump Tips :: 5.4.5.3 Dumping Stored Programs
Section Navigation [Toggle]
Several options control how mysqldump handles stored programs (stored functions and procedures and triggers):
--routines: Dump stored functions and procedures--triggers: Dump triggers for tables
The --triggers option is
enabled by default so that when tables are dumped, they are
accompanied by any triggers they have. The other options are
disabled by default and must be specified explicitly to dump
the corresponding objects. To disable any of these options
explicitly, use its skip form:
--skip-routines
or
--skip-triggers.
