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

backup mysql mysql 5.7

Segragating First LSN and Last LSN from Output MySQL

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

Add your own answers!

Related Questions

Why does MySQL wait for a table lock for a validation query?

how to update SSRS execution account automatically through power-shell?

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

Does pg_dump flag -j give performance improvement up to -j 16 or -j 32 or even -j 64?

MySQL nested groupby with count other field

How can I transpose multiple unrelated columns into rows in SQL Server?

MySQL Query causing high CPU and taking forever to execute

Postgres files postgresql.conf and pg_hba.conf – which take priority?

Drizzle database system design questions – architecture &c

Update staging table records in SQL Server 2017 with INSERT trigger and table-valued function, using INSERTED records

What’s the meaning of “resources external to the SQL Server computer are needed” in Microsoft’s SQL documentation?

Article table has a lot of null. What is the best way to prevent null in MySQL

Full text search on larger text rows

Select a count of record sharing the same value than record X

GRANT ROLE TO USER in MySQL

Error passing variable table type to a stored procedure

Is there any unique identifier for PostgreSQL? How can the master identify its slave unqiuely?

Why BCP creates such big files?

How to maintain customer addresses for Orders?

Table size and row count

Ask a Question