Bug #49351 start_time and end_time in mysql . backup_history are off by several hours
Submitted: 2 Dec 2009 13:57 Modified: 2 Dec 2009 15:17
Reporter: Philip Stoev Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:6.0-backup OS:Any
Assigned to: CPU Architecture:Any

[2 Dec 2009 13:57] Philip Stoev 
Description:
The timestamps in the mysql . backup_history table are not in the current wallclock time or time zone in effect. Seems to me they are in UTC or something similar.

How to repeat:
mysql> backup database test to '/tmp/test';
mysql> select start_time , now() from mysql.backup_history\G
*************************** 1. row ***************************
start_time: 2009-12-02 13:56:04
     now(): 2009-12-02 16:56:41
[2 Dec 2009 13:58] Philip Stoev 
This makes it difficult to correlate the error messages from the log with the contents of the tables.
[2 Dec 2009 15:17] Chuck Bell 
Duplicate of BUG#37164 which is waiting on WL#5051 to be completed. Once this work is completed, the backup logs will obey local timezone. Until then, know that they are stored as UTC.