Tuesday 4 October 2016

mysqlbackup: WARNING: binlog file 'mysql-bin.000161' does not exist. It could have been purged. PITR will not be possible from this backup.

Issue:-
  
  Tape mysqlbackup failed because of below WARNING msg.
  
  mysqlbackup: WARNING: binlog file 'mysql-bin.000161' does not exist. It could have been purged. PITR will not be possible from this backup.
   
 
  Solution:-
 
  login to mysqlDB & check master status.
 
  show master status;
 
  if you see multiple Executed_Gtid_Set
 
  reset master;

  show master status;
 
  this time get single Executed_Gtid_Set
 

  re-run Tape mysqlbackup & check error log.