MySQL Forums
Forum List  »  Backup

MYSQL Enterpise Backup- Identifying Binlog position
Posted by: Varun Datta
Date: January 09, 2013 10:38PM


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!!

Varun Datta

Options: ReplyQuote

Written By
MYSQL Enterpise Backup- Identifying Binlog position
January 09, 2013 10:38PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.