Bug #74937 Store backup location
Submitted: 20 Nov 2014 8:59 Modified: 31 May 2016 9:59
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Backup Severity:S4 (Feature request)
Version:3.11.0 OS:Any
Assigned to: CPU Architecture:Any

[20 Nov 2014 8:59] Daniël van Eeden 
Description:
Please store the location of the backup.

The original location is stored in mysql.backup_history.backup_destination.

How to repeat:
See description

Suggested fix:
Add a column current_backup_location which can be set to ORIGINAL (=backup_destination) or UNKNOWN, TAPE (SBT).

Then run "myqlbackup check-location" which gets the backup_destination from mysql.backup_history and tests if it still exists.

This could be used for incrementals: incremental_base=backup_history:last_present_full to make sure a incremental is based on an existing full backup and not based on a deleted full backup.
The only issue is that it's hard to keep this data up to data as backups may be picked up with a filesystem backup agent and the removed by a cronjob.
[31 May 2016 9:58] Anandakumar S 
Hi Daniël van Eeden,

Thank you for the feature request. 

Thanks
Anand