(mysql.info.gz) Backup strategy summary

Info Catalog

(mysql.info.gz) Backup recovery

(mysql.info.gz) Backup strategy example

 
 5.7.2.3 Backup Strategy Summary
 ...............................
 
 In case of an operating system crash or power failure, `InnoDB' itself
 does all the job of recovering data. But to make sure that you can
 sleep well, observe the following guidelines:
 
    * Always run the MySQL server with the `--log-bin' option, or even
      `--log-bin=LOG_NAME', where the log file name is located on some
      safe media different from the drive on which the data directory is
      located. If you have such safe media, this will also be good for
      disk load balancing (which results in a performance improvement).
 
    * Make periodic full backups, using the last `mysqldump' command
      given earlier that makes an online, non-blocking backup.
 
    * Make periodic incremental backups by flushing the logs with `FLUSH
      LOGS' or `mysqladmin flush-logs'.
 
 

Info Catalog

(mysql.info.gz) Backup recovery

(mysql.info.gz) Backup strategy example