Forum Stats

  • 3,769,349 Users
  • 2,252,952 Discussions
  • 7,874,993 Comments

Discussions

How to get from LSN to timestamp/position

R.Jonas
R.Jonas Member Posts: 7
edited May 21, 2020 10:54AM in MySQL Community Space

Hello,

I've an actual full backup via integration of incremental backups, done by enterprise backup.

Restoring this was done. But how do I identify timestamp or position in binlog to load delta?

Enterprise Backup writes LSN to protocol file. For point-in-time recovery I need to load delta (between time of producing increment and time of server crash) from mysql binlogs. In binlog I can't find LSN, only timestamp or position is noted there.

How do I get this information?

Regards,

R.Jonas

Tagged:

Answers