[MDEV-8997] Add to mysqlbinlog --start-date and --end-date Created: 2015-10-22  Updated: 2017-05-29

Status: Open
Project: MariaDB Server
Component/s: Scripts & Clients
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Fustini Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: None


 Description   

Print the first date --start-date and / or last date --end-date present in the specific binlog file



 Comments   
Comment by Sergei Golubchik [ 2015-11-02 ]

Could you elaborate on that, please? What should it print? How these new options are supposed to be used (what's your use case)?

Comment by Fustini [ 2015-11-02 ]

Hi,
I want to store binlog for Point In Time Recover automatic procedure.
To restore with a PITR I have to store Start date time and End date time for single bin log to know which one use.
Now I have to print and parse all output from a bin log and get the first date and the last date to have this data from binlog.
With --start-date and --end-date I suppose to have an output formatted like YYYYMMDDHHMMSS to get it easly with anything scripting language
mysqlbinlog --start-date /binlog/examplelog
20151101001111 First date
mysqlbinlog --end-date /binlog/examplelog
20151101011111 End date
mysqlbinlog --start-date --end-date /binlog/examplelog
20151101001111 First date
20151101011111 End date

Thank you very much

Generated at Thu Feb 08 07:31:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.