AnswerBun.com

Segragating First LSN and Last LSN from Output MySQL

Database Administrators Asked by JABIR BAIG on December 24, 2020

I am trying to Build a Incremental Backup Script using Percona Innobackupex , what my problem is i need a shell script to segregate the both First LSN and Last LSN from the Log Output of Full Backup, lets say my Output from the log File is

cat /data/test_backup/test.log | grep "Transaction log of lsn"

xtrabackup: Transaction log of lsn (38491856810) to (38491856819) was copied.

i want to segregate the data in the braces as

FirstLSN = 38491856810
LastLSN = 38491856819

into an output file and use the Last LSN to take incremental Backup or append the LSN Detail directly to my Full backup Script running Log

Add your own answers!

Related Questions

SQL Server :: how to move country code column to another table?

1  Asked on January 9, 2021 by francesco-mantovani

       

MySQL nested groupby with count other field

0  Asked on January 8, 2021 by jayakusumah

     

GRANT ROLE TO USER in MySQL

1  Asked on January 3, 2021 by rj_n

       

Why BCP creates such big files?

1  Asked on January 1, 2021 by racer-sql

     

Table size and row count

1  Asked on December 31, 2020

 

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP