| Bug #43515 | There is no way to use user_comment option from backup_history log. | ||
|---|---|---|---|
| Submitted: | 9 Mar 2009 22:18 | Modified: | 5 Oct 2010 7:42 |
| Reporter: | Hema Sridharan | Email Updates: | |
| Status: | Unsupported | Impact on me: | |
| Category: | MySQL Server: Backup | Severity: | S3 (Non-critical) |
| Version: | 6.0 bzr | OS: | Linux |
| Assigned to: | Chuck Bell | CPU Architecture: | Any |
[10 Mar 2009 6:54]
Sveta Smirnova
Thank you for the report. Verified as described.
[12 Mar 2009 21:47]
Chuck Bell
From the email documenting the meeting notes between Peter G, Robin S, and the backup developers concerning the syntax of the BACKUP DATABASE command:
Hi all,
These are the minutes of
Online Backup: meeting in Orlando, 2007-01-09 afternoon
Present: Lars, Rafal, Chuck, Peter
Robin, there are two questions for you, at the end.
Topic: Proposals to Change BACKUP DATABASE syntax
Current syntax
--------------
BACKUP ALL | { DATABASE * } | { DATABASE database_name ...] TO 'filename';
...
TAG or COMMENT
(this would go in the repository)
Decision: yes in first release, and it's COMMENT
---
Therefore, this was planned for 6.0 and must be implemented.
[15 Mar 2009 19:57]
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/69253 2801 Chuck Bell 2009-03-15 BUG#43515 : There is no way to use user_comment option from backup_history log This patch adds the user_comment to the RESTORE and BACKUP commands. modified: mysql-test/suite/backup/r/backup_logs.result mysql-test/suite/backup/t/backup_logs.test sql/backup/backup_kernel.h sql/backup/kernel.cc sql/backup/logger.h sql/si_logs.cc sql/si_logs.h sql/sql_yacc.yy
[2 Dec 2009 10:54]
Lars Thalmann
The column is reserved for future use. We currently have no plans to fix this. Setting to "won't fix".
[22 Jan 2010 16:38]
Hema Sridharan
Lars added this to long term plan and so marking to verified state.
[5 Oct 2010 7:42]
Ingo Strüwing
The feature will not be implemented.
Description: The backup history log has user_comment column that can be specified by the user at the command line. Currently the backup and restore syntax does not have this option to specify. How to repeat: The backup logs has following options, mysql> select * from mysql.backup_history\G *************************** 1. row *************************** backup_id: 270 process_id: 0 binlog_pos: 0 binlog_file: backup_state: complete operation: backup error_num: 0 num_objects: 3 total_bytes: 4250 validity_point_time: 2009-03-09 20:54:26 start_time: 2009-03-09 20:54:25 stop_time: 2009-03-09 20:54:26 host_or_server_name: localhost username: root backup_file: db1.bak backup_file_path: /review/mysql-6.0-backup/mysql-test/var/mysqld.1/data/ user_comment:=======================> How to use this option? command: backup database db1 to 'db1.bak' drivers: MyISAM If this column is of no purpose, then either it should be removed or should be documented with the limitation. According to Chuck, backup and restore commands needs to be changed.