<div id="docs-body">
 <div class="chapter">
  <div class="titlepage">
   <div>
    <div>
     <h1 class="title">
      <a name="backup-and-recovery">
      </a>
      Chapter 9 Backup and Recovery
     </h1>
    </div>
   </div>
  </div>
  <div class="toc">
   <p>
    <b>
     Table of Contents
    </b>
   </p>
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="backup-types.html">
       9.1 Backup and Recovery Types
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="backup-methods.html">
       9.2 Database Backup Methods
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="backup-strategy-example.html">
       9.3 Example Backup and Recovery Strategy
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="backup-policy.html">
         9.3.1 Establishing a Backup Policy
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="recovery-from-backups.html">
         9.3.2 Using Backups for Recovery
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="backup-strategy-summary.html">
         9.3.3 Backup Strategy Summary
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="using-mysqldump.html">
       9.4 Using mysqldump for Backups
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="mysqldump-sql-format.html">
         9.4.1 Dumping Data in SQL Format with mysqldump
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="reloading-sql-format-dumps.html">
         9.4.2 Reloading SQL-Format Backups
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="mysqldump-delimited-text.html">
         9.4.3 Dumping Data in Delimited-Text Format with mysqldump
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="reloading-delimited-text-dumps.html">
         9.4.4 Reloading Delimited-Text Format Backups
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="mysqldump-tips.html">
         9.4.5 mysqldump Tips
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="point-in-time-recovery.html">
       9.5 Point-in-Time (Incremental) Recovery
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="point-in-time-recovery-binlog.html">
         9.5.1 Point-in-Time Recovery Using Binary Log
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="point-in-time-recovery-positions.html">
         9.5.2 Point-in-Time Recovery Using Event Positions
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="myisam-table-maintenance.html">
       9.6 MyISAM Table Maintenance and Crash Recovery
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="myisam-crash-recovery.html">
         9.6.1 Using myisamchk for Crash Recovery
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="myisam-check.html">
         9.6.2 How to Check MyISAM Tables for Errors
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="myisam-repair.html">
         9.6.3 How to Repair MyISAM Tables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="myisam-optimization.html">
         9.6.4 MyISAM Table Optimization
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="myisam-maintenance-schedule.html">
         9.6.5 Setting Up a MyISAM Table Maintenance Schedule
        </a>
       </span>
      </dt>
     </dl>
    </dd>
   </dl>
  </div>
  <a class="indexterm" name="idm46045231410352">
  </a>
  <a class="indexterm" name="idm46045231408864">
  </a>
  <p>
   It is important to back up your databases so that you can recover
    your data and be up and running again in case problems occur, such
    as system crashes, hardware failures, or users deleting data by
    mistake. Backups are also essential as a safeguard before upgrading
    a MySQL installation, and they can be used to transfer a MySQL
    installation to another system or to set up replica servers.
  </p>
  <p>
   MySQL offers a variety of backup strategies from which you can
    choose the methods that best suit the requirements for your
    installation. This chapter discusses several backup and recovery
    topics with which you should be familiar:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Types of backups: Logical versus physical, full versus
        incremental, and so forth.
     </p>
    </li>
    <li class="listitem">
     <p>
      Methods for creating backups.
     </p>
    </li>
    <li class="listitem">
     <p>
      Recovery methods, including point-in-time recovery.
     </p>
    </li>
    <li class="listitem">
     <p>
      Backup scheduling, compression, and encryption.
     </p>
    </li>
    <li class="listitem">
     <p>
      Table maintenance, to enable recovery of corrupt tables.
     </p>
    </li>
   </ul>
  </div>
  <h2>
   <a name="idm46045231401648">
   </a>
   Additional Resources
  </h2>
  <p>
   Resources related to backup or to maintaining data availability
    include the following:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product for backups. For an
        overview of the MySQL Enterprise Backup product, see
      <a class="xref" href="mysql-enterprise-backup.html" title="32.1 MySQL Enterprise Backup Overview">
       Section 32.1, “MySQL Enterprise Backup Overview”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      A forum dedicated to backup issues is available at
      <a class="ulink" href="https://forums.mysql.com/list.php?28" target="_blank">
       https://forums.mysql.com/list.php?28
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Details for
      <a class="link" href="mysqldump.html" title="6.5.4 mysqldump — A Database Backup Program">
       <span class="command">
        <strong>
         mysqldump
        </strong>
       </span>
      </a>
      can be found in
      <a class="xref" href="programs.html" title="Chapter 6 MySQL Programs">
       Chapter 6,
       <i>
        MySQL Programs
       </i>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      The syntax of the SQL statements described here is given in
      <a class="xref" href="sql-statements.html" title="Chapter 15 SQL Statements">
       Chapter 15,
       <i>
        SQL Statements
       </i>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      For additional information about
      <code class="literal">
       InnoDB
      </code>
      backup procedures, see
      <a class="xref" href="innodb-backup.html" title="17.18.1 InnoDB Backup">
       Section 17.18.1, “InnoDB Backup”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Replication enables you to maintain identical data on multiple
        servers. This has several benefits, such as enabling client
        query load to be distributed over servers, availability of data
        even if a given server is taken offline or fails, and the
        ability to make backups with no impact on the source by using a
        replica. See
      <a class="xref" href="replication.html" title="Chapter 19 Replication">
       Chapter 19,
       <i>
        Replication
       </i>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      MySQL InnoDB Cluster is a collection of products that work
        together to provide a high availability solution. A group of
        MySQL servers can be configured to create a cluster using
        MySQL Shell. The cluster of servers has a single source, called
        the primary, which acts as the read-write source. Multiple
        secondary servers are replicas of the source. A minimum of three
        servers are required to create a high availability cluster. A
        client application is connected to the primary via MySQL Router. If
        the primary fails, a secondary is automatically promoted to the
        role of primary, and MySQL Router routes requests to the new
        primary.
     </p>
    </li>
    <li class="listitem">
     <p>
      NDB Cluster provides a high-availability, high-redundancy
        version of MySQL adapted for the distributed computing
        environment. See
      <a class="xref" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
       Chapter 25,
       <i>
        MySQL NDB Cluster 8.4
       </i>
      </a>
      , which provides
        information about MySQL NDB Cluster
        8.4.0.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
