<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysqldump-tips">
      </a>
      9.4.5 mysqldump Tips
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="mysqldump-copying-database.html">
       9.4.5.1 Making a Copy of a Database
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysqldump-copying-to-other-server.html">
       9.4.5.2 Copy a Database from one Server to Another
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysqldump-stored-programs.html">
       9.4.5.3 Dumping Stored Programs
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysqldump-definition-data-dumps.html">
       9.4.5.4 Dumping Table Definitions and Content Separately
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysqldump-upgrade-testing.html">
       9.4.5.5 Using mysqldump to Test for Upgrade Incompatibilities
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <p>
   This section surveys techniques that enable you to use
   <a class="link" href="mysqldump.html" title="6.5.4 mysqldump — A Database Backup Program">
    <span class="command">
     <strong>
      mysqldump
     </strong>
    </span>
   </a>
   to solve specific problems:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      How to make a copy a database
     </p>
    </li>
    <li class="listitem">
     <p>
      How to copy a database from one server to another
     </p>
    </li>
    <li class="listitem">
     <p>
      How to dump stored programs (stored procedures and
            functions, triggers, and events)
     </p>
    </li>
    <li class="listitem">
     <p>
      How to dump definitions and data separately
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
