Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get from LSN to timestamp/position

R.JonasMay 19 2020 — edited May 21 2020

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

Comments

Post Details

Added on May 19 2020
1 comment
505 views