Bug #48353 Add PURGE BACKUPLOGS to mysqladmin.
Submitted: 27 Oct 2009 15:55 Modified: 23 Feb 2010 1:54
Reporter: Ritheesh Vedire Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Chuck Bell CPU Architecture:Any
Tags: mysqladmin, purge backup logs

[27 Oct 2009 15:55] Ritheesh Vedire
Description:
BUG#47493 adds 'flush-backup-logs' to mysqladmin.
'purge backup-logs' feature  should be added to mysqladmin as it acts as a companion command to 'flush-backup-logs'.

How to repeat:
mysqladmin --help.

Suggested fix:
Add the feature to mysqladmin.
[13 Nov 2009 1:52] Chuck Bell
Chuck steals a bug.
[13 Nov 2009 1:54] 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/90297

2890 Chuck Bell	2009-11-12
      BUG#48353 : Add PURGE BACKUPLOGS to mysqladmin
      
      It has been decided the PURGE BACKUP LOGS is a companion to
      the FLUSH BACKUP LOGS command and should be added to the 
      options for mysqladmin.
      
      This patch adds the PURGE BACKUP LOGS command.
      
      Note: WL#5165  was created to provide more advanced testing of
      FLUSH/PURGE BACKUP LOGS.
     @ client/mysqladmin.cc
        Added code to call the SQL command PURGE BACKUP LOGS.
        Added commentary for help and command case for the options
        switch.
     @ mysql-test/suite/backup/r/backup_logs_output.result
        Corrected result file.
     @ mysql-test/suite/backup/t/backup_logs_output.test
        Added call to mysqladmin with purge backup logs command.
[13 Nov 2009 15: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/90367

2891 Chuck Bell	2009-11-13
      BUG#48353 : Add PURGE BACKUPLOGS to mysqladmin
      
      It has been decided the PURGE BACKUP LOGS is a companion 
      to the FLUSH BACKUP LOGS command and should be added to 
      the options for mysqladmin.
      
      This patch adds the PURGE BACKUP LOGS command. There are
      three forms of this command:
      
        PURGE BACKUP LOGS
        PURGE BACKUP LOGS TO <id>
        PURGE BACKUP LOGS BEFORE <date>
      
      This patch adds the following options to mysqladmin:
      
        purge-backup-logs       Purge backup logs
        purge-backup-logs-id    Purge backup logs up to a given backup_id
        purge-backup-logs-date  Purge backup logs before a given date
      
      Note: WL#5165  was created to provide more advanced testing of
            FLUSH/PURGE BACKUP LOGS.
     @ client/mysqladmin.cc
        Added new commands to mysqladmin.
     @ mysql-test/suite/backup/r/backup_logs_output.result
        Corrected result file.
     @ mysql-test/suite/backup/t/backup_logs_output.test
        Added tests for new commands.
[16 Nov 2009 15:22] 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/90527

2890 Chuck Bell	2009-11-16
      BUG#48353 : Add PURGE BACKUPLOGS to mysqladmin
      
      It has been decided the PURGE BACKUP LOGS is a companion 
      to the FLUSH BACKUP LOGS command and should be added to 
      the options for mysqladmin.
      
      This patch adds the PURGE BACKUP LOGS command. There are
      three forms of this command:
      
        PURGE BACKUP LOGS
        PURGE BACKUP LOGS TO <id>
        PURGE BACKUP LOGS BEFORE <date>
      
      This patch adds the following options to mysqladmin:
      
        purge-backup-logs       Purge backup logs
        purge-backup-logs-id    Purge backup logs up to a given backup_id
        purge-backup-logs-date  Purge backup logs before a given date
      
      Note: WL#5165  was created to provide more advanced testing of
            FLUSH/PURGE BACKUP LOGS.
     @ client/mysqladmin.cc
        Added code to call the SQL command PURGE BACKUP LOGS.
        Added commentary for help and command case for the options
        switch.
     @ mysql-test/suite/backup/r/backup_logs_output.result
        Corrected result file.
     @ mysql-test/suite/backup/t/backup_logs_output.test
        Added call to mysqladmin with purge backup logs command.
        Added tests for new commands.
[17 Nov 2009 15:35] 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/90690

2891 Chuck Bell	2009-11-17 [merge]
      local merge before push for BUG#48353
[17 Nov 2009 16:11] 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/90698

2892 Chuck Bell	2009-11-17 [merge]
      local merge before push for BUG#48353
[17 Dec 2009 21:40] 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/94869

2919 Chuck Bell	2009-12-17
      PB Fix - BUG#48353
      
      Some platforms (Windows) splits the date and time as two parameters.
      Changing single quotes to double quotes solves the problem.
      
      Pushed by MC - CAB.
[20 Feb 2010 9:16] Bugs System
Pushed into 6.0.14-alpha (revid:ingo.struewing@sun.com-20100218152520-s4v1ld76bif06eqn) (version source revid:ingo.struewing@sun.com-20100119103538-wtp5alpz4p2jayl5) (merge vers: 6.0.14-alpha) (pib:16)
[23 Feb 2010 1:54] Paul DuBois
Noted in 6.0.14 changelog.

mysqladmin now has purge-backup-logs, purge-backup-logs-id, and
purge-backup-logs-date commands to purge the backup logs. These are
equivalent to the various forms of the PURGE BACKUP LOGS statement.

Also updated mysqladmin section.