|
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
|