Documentation Home
MySQL Backup and Recovery
Related Documentation Download this Excerpt
PDF (US Ltr) - 346.7Kb
PDF (A4) - 344.1Kb
EPUB - 110.5Kb
HTML Download (TGZ) - 71.5Kb
HTML Download (Zip) - 78.3Kb


MySQL Backup and Recovery  /  ...  /  Dumping Stored Programs

1.4.5.3 Dumping Stored Programs

Several options control how mysqldump handles stored programs (stored procedures and functions, triggers, and events):

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.


User Comments
Sign Up Login You must be logged in to post a comment.