(mysql.info) point-in-time-recovery

(mysql.info) backup-strategy-example

 
 5.10.3 Point-in-Time Recovery
 -----------------------------

 
* point-in-time-recovery-times  Specifying Times for Recovery
* point-in-time-recovery-positions  Specifying Positions for Recovery
 
 If a MySQL server was started with the -log-bin option to enable binary
 logging, you can use the `mysqlbinlog' utility to recover data from the
 binary log files, starting from a specified point in time (for example,
 since your last backup) until the present or another specified point in
 time. For information on enabling the binary log and using
 `mysqlbinlog', see  binary-log, and  mysqlbinlog.
 
 To restore data from a binary log, you must know the location and name
 of the current binary log file. By default, the server creates binary
 log files in the data directory, but a pathname can be specified with
 the -log-bin option to place the files in a different location.
 Typically the option is given in an option file (that is, `my.cnf' or
 `my.ini', depending on your system). It can also be given on the
 command line when the server is started. To determine the name of the
 current binary log file, issue the following statement:
 
      mysql> SHOW BINLOG EVENTS\G
 
 If you prefer, you can execute the following command from the command
 line instead:
 
      shell> mysql -u root -p -E -e "SHOW BINLOG EVENTS"
 
 Enter the `root' password for your server when `mysql' prompts you for
 it.

Info Catalog

(mysql.info) backup-strategy-example

(mysql.info) disaster-prevention

(mysql.info) table-maintenance

automatically generated byinfo2html

(mysql.info) point-in-time-recovery

Menu