MySQL binlog Point-in-time Recovery (mysqlbinlog)

Just for my own quick reference

Official Document:

Some Important parameters:

To generate human readable and grep-able SQL for binlog_format=row:
--base64-output=DECODE-ROWS --verbose

To specify datetime range:

To specify binlog position:


Create SQL within specified time-frame:

Create SQL within specified binlog position:

Restore generated SQL:


Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.