Solved

mysql transaction log backup failed - binary logs missing

  • 5 November 2022
  • 2 replies
  • 503 views

Userlevel 1
Badge +3

Hi,

 

Our MySQL DB admin has removed some transactions logs from DB side. No we recieve following error in incremental backup.

 

our full backup is a snap backup. So after the full, incremental are also failing with the same error. what we can do to fix this without purging logs from D side ? Really appreciate the help at this point.

icon

Best answer by InnoV8 7 November 2022, 00:26

View original

2 replies

Badge

Hello,

For the MySQL transaction log 

you should use this path:   /var/lib/mysql

From The Properties of MySQL server panel, put the correct path for the Log Directory :  /var/lib/mysql

 

 

Badge

To fix the issue, please refer to https://documentation.commvault.com/commvault/v11_sp20/article?p=19483.htm#o19526 Section MSQL0010: Error Code [87:90] Full or log-only backup operation fails

Note that this is a MySQL  end side issue which is happening due to the fact that binary logs were manually removed.

Reply