Bug #39690 Backup logs need to split backup image file into path and filename columns
Submitted: 26 Sep 2008 20:31 Modified: 30 Oct 2008 19:30
Reporter: Chuck Bell Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S4 (Feature request)
Version:6.0.8 OS:Any
Assigned to: Chuck Bell CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request) / R1 (None/Negligible) / E1 (None/Negligible)

[26 Sep 2008 20:31] Chuck Bell
Description:
The backup history log has a column named 'backup_file'. This column stores the backup image file. Currently, the value is the adjusted path of the backup image file. 

This is neither useful or friendly. The logs need to store the calculated path to the backup image file with all relative applications sorted as well as the application of the backupdir variable.  This path should be stored separately from the backup image file. This will make working with the log much easier and more informative.

How to repeat:
NA

Suggested fix:
Change the backup_file column so that only the name of the backup image file is stored.

Add a new column named 'backup_file_path' that stores the calculated path to the backup image file.
[26 Sep 2008 20:32] Chuck Bell
This patch is required to solve part of BUG#33364.
[26 Sep 2008 20:32] Chuck Bell
Patch created.
[26 Sep 2008 21:15] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/54584

2698 Chuck Bell	2008-09-26
      BUG#39690 Backup logs need to split backup image file into path and filename columns 
      
      This patch adds the backup_file_path column to the backup_history log.
      The logic has been changed to store the exact path to the backup
      image file as calculated in the stream class.
[8 Oct 2008 14:05] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/55777

2702 Chuck Bell	2008-10-08
      BUG#39690 Backup logs need to split backup image file into path and filename columns
      
      This patch adds the backup_file_path column to the backup_history log.
      The logic has been changed to store the exact path to the backup
      image file as calculated in the stream class.
[13 Oct 2008 9:54] Jørgen Løland
Good to push
[14 Oct 2008 8:26] Rafal Somla
Change requested.
[15 Oct 2008 20:01] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/56297

2711 Chuck Bell	2008-10-15
      BUG#39690 Backup logs need to split backup image file into path and filename columns
      
      This patch adds the backup_file_path column to the backup_history log.
      The logic has been changed to store the exact path to the backup
      image file as calculated in the stream class.
[16 Oct 2008 11:37] Rafal Somla
Good to push.
[30 Oct 2008 12:45] Bugs System
Pushed into 6.0.8-alpha  (revid:cbell@mysql.com-20081015200048-38lg9rpl0bpn823y) (version source revid:cbell@mysql.com-20081015200048-38lg9rpl0bpn823y) (pib:5)
[30 Oct 2008 19:30] Paul Dubois
Noted in 6.0.8 changelog.

The MySQL Backup backup_history log now contains a backup_file_path
column. backup_file contains the basename and backup_file_path
contains the directory of the image file pathname.