Bug #47493 Backup logs cannot be flushed with mysqladmin

• Submitted: 21 Sep 2009 18:40
• Modified: 22 Feb 2010 21:11
• Reporter: Chuck Bell
• Status: Closed
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• Version: 5.4.4
• OS: Any
• Assigned to: Ritheesh Vedire
• CPU Architecture: Any

[21 Sep 2009 18:40] Chuck Bell

Description:
The mysqladmin program has commands that correspond to a number of FLUSH options:

mysqladmin --help:

...
  flush-hosts           Flush all cached hosts
  flush-logs            Flush all logs
  flush-status        Clear status variables
  flush-tables          Flush all tables
  flush-threads         Flush the thread cache
  flush-privileges      Reload grant tables (same as reload)
...

But there isn't a flush-backup-logs command. There should be an option to flush the backup logs from the mysqladmin tool.

How to repeat:
mysqladmin --help

Suggested fix:
Add the feature to the mysqladmin application.

[21 Sep 2009 19:45] Sveta Smirnova

Thank you for the report.

Verified as described.

[20 Oct 2009 9:47] 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/87439

2879 Ritheesh Vedire	2009-10-20
      BUG#47493: Add 'flush backup logs' feature to mysqladmin 
     @ client/mysqladmin.cc
        Added the feature.  I have no idea how to write a test script for it.

[21 Oct 2009 12:27] 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/87631

2880 Ritheesh Vedire	2009-10-21
      BUG#47493:  Add 'flush-backup-logs' to mysqladmin
     @ client/mysqladmin.cc
        used already existing sql command  'flush backup logs' .

[21 Oct 2009 14:17] 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/87660

2880 Ritheesh Vedire	2009-10-21
      BUG#47493: add 'flush-backup-logs'  feature to mysqladmin
     @ client/mysqladmin.cc
        Used the existing SQL command 'flush backup logs'.
     @ mysql-test/suite/backup/t/backup_logs_output.test
        Irrespective of log_backup_output options log files are created.
        So I have tested  only for TABLE,FILE option. 
        The command doesn't return anything when it succeeds.

[21 Oct 2009 14:51] Rafal Somla

Approved pending changes.

[26 Oct 2009 9:17] 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/88116

2884 Ritheesh Vedire	2009-10-26
      BUG#47493: Backup logs cannot be flushed with mysqladmin.
     @ client/mysqladmin.cc
         Used the existing SQL command 'flush backup logs'.
         Changed the code format.
     @ mysql-test/suite/backup/t/backup_logs_output.test
         Irrespective of log_backup_output options log files are created.
         So I have tested  only for TABLE,FILE option. 
         The command doesn't return anything when it succeeds.

[27 Oct 2009 15:13] Chuck Bell

Patch approved under condition that a new bug report will be opened that addresses the following issues:

* The existing test case for flush backup logs is insufficient
* The purge backup logs command should be part of mysqladmin

[20 Feb 2010 9:18] Bugs System

Pushed into 6.0.14-alpha (revid:[e-mail]-20100218152520-s4v1ld76bif06eqn) (version source revid:[e-mail]-20100119103538-wtp5alpz4p2jayl5) (merge vers: 6.0.14-alpha) (pib:16)

[22 Feb 2010 21:11] Paul DuBois

Noted in 6.0.14 changelog.

mysqladmin now has a flush-backup-logs command to flush the backup
logs. This is equivalent to using the FLUSH BACKUP LOGS statement.

Also updated mysqladmin section.