Bug #39690 Backup logs need to split backup image file into path and filename columns

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.

This patch is required to solve part of BUG#33364.

Patch created.

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.

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.

Good to push

Change requested.

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.

Good to push.

Pushed into 6.0.8-alpha  (revid:cbell@mysql.com-20081015200048-38lg9rpl0bpn823y) (version source revid:cbell@mysql.com-20081015200048-38lg9rpl0bpn823y) (pib:5)

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.