Point-In-Time Recovery

If a MySQL server was started with the --log-bin option to enable binary logging, use the mysqlbinlog utility to recover data from the binary log files
- Start from a specified point in time
  - For example, since the last backup.

To restore data from a binary log, one must know the location and name of the current binary log file.
- By default, the server creates binary log files in the data directory.
- A pathname can be specified with the --log-bin option to place the files in a different location.
  - Typically the option is given in the my.cnf file.
  - 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:

How do I specify recovery time?

© 2007 John Michael Pierobon

Notes