Not the answer you need?
Register and ask your own question!

How do i get the last lsn number if i am Streaming the Backup?ly 2 ways i

RiteshRitesh EntrantCurrent User Role Beginner
Hi want to use the steaming feature of taking backup. Steaming works but i need to get the lsn number so that i can take incrementals later. The only 2 ways i see is i will have to openup the backup tar and read the backup file or from stdout get the last lsn. Question is , is there a better way ?


  • mreitingermreitinger Entrant Inactive User Role Beginner
    Use the parameter --extra-lsndir=path to make innobackupex write a copy of the xtrabackup_checkpoints file in a specific directory. You can then extract the LSN from this file after the backup finished.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.