Spec-Zone .ru
спецификации, руководства, описания, API
|
Several options control how mysqldump handles stored programs (stored procedures and functions, triggers, and events):
--events
:
Dump Event Scheduler events
--routines
:
Dump stored procedures and functions
--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-events
, --skip-routines
, or --skip-triggers
.