<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysqldump-stored-programs">
      </a>
      9.4.5.3 Dumping Stored Programs
     </h4>
    </div>
   </div>
  </div>
  <p>
   Several options control how
   <a class="link" href="mysqldump.html" title="6.5.4 mysqldump — A Database Backup Program">
    <span class="command">
     <strong>
      mysqldump
     </strong>
    </span>
   </a>
   handles stored programs (stored procedures and functions,
          triggers, and events):
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="mysqldump.html#option_mysqldump_events">
       <code class="option">
        --events
       </code>
      </a>
      : Dump Event
              Scheduler events
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysqldump.html#option_mysqldump_routines">
       <code class="option">
        --routines
       </code>
      </a>
      : Dump stored
              procedures and functions
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="mysqldump.html#option_mysqldump_triggers">
       <code class="option">
        --triggers
       </code>
      </a>
      : Dump
              triggers for tables
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <a class="link" href="mysqldump.html#option_mysqldump_triggers">
    <code class="option">
     --triggers
    </code>
   </a>
   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:
   <a class="link" href="mysqldump.html#option_mysqldump_events">
    <code class="option">
     --skip-events
    </code>
   </a>
   ,
   <a class="link" href="mysqldump.html#option_mysqldump_routines">
    <code class="option">
     --skip-routines
    </code>
   </a>
   ,
          or
   <a class="link" href="mysqldump.html#option_mysqldump_triggers">
    <code class="option">
     --skip-triggers
    </code>
   </a>
   .
  </p>
 </div>
 <br/>
</div>
