1 Reply Latest reply on May 21, 2020 2:54 PM by Dave Stokes-MySQL Community Team-Oracle

    How to get from LSN to timestamp/position

    R.Jonas

      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