MYSQL Enterpise Backup- Identifying Binlog position

[Varun Datta]

Hi,

We are exploring MYSQL Enterprise Backup. We do not have support right now.

I have one query if any one can answer.

If we are taking full backup using below command:-

mysqlbackup --port=3306 --protocol=tcp --user=root --password=mysql123 --backup-dir=/MYSQL/backup/master_backup backup-and-apply-log

Then how do we identify till which binary log file and position the above backup contains data.

I need this information to be extracted from backup so that i can save this information which will help in Point-in-Time Recovery.

If i do flush tables with read lock before i take backup, my backup fails, so i do not know how should i get the binlog file and position till which i have data restored from backup.

Quick reply will really help!!

Thanks,
Varun Datta