Bug #43072 backup time "am"

• Submitted: 21 Feb 2009 5:01
• Modified: 10 Mar 2009 12:20
• Reporter: Jared S (Silver Quality Contributor)
• Status: Won't fix
• Category: MySQL Administrator
• Severity: S4 (Feature request)
• Version: 1.2.16
• OS: Windows (NT x.x)
• CPU Architecture: Any
• Tags: am, Backup, qc

[21 Feb 2009 5:01] Jared S

Description:
Backing up at say "2:00 am" wont fire under scheduled tasks.  Although backing up at "2:00 AM" works as expected.

How to repeat:
1. Load Adminstrator
2. Create backup
3. Change PM to "am"
4. Schedule
5. Goto schedule task and fire event manually

RESULT backup file is not created

Suggested fix:
Make "am" compatible or improve data verification of Administrator.
-Also consider making default time 12:00 noon\midnight everybody would want to do backup at 00 minutes anyway.

[26 Feb 2009 13:55] MySQL Verification Team

Thank you for the bug report. Which is your setting of symbol a.m in your regional settings?. Thanks in advance.

[26 Feb 2009 14:08] MySQL Verification Team

symbol a.m

Attachment: hour.PNG (image/png, text), 43.88 KiB.

[26 Feb 2009 20:03] Jared S

EN-AU symboly for AM is "AM" in uppercase on NT 6.0.

[4 Mar 2009 13:36] MySQL Verification Team

Thank you for the feedback. I assume that your regional setting in Windows are configured to use the format of 12 h instead of 24 h. According the MA Manual, item: 16.4. Schedule "..by setting the Time option. Set the backup time in a 24 hour format (i.e. 23:30).". So I think this a feature request.

[4 Mar 2009 21:01] Jared S

- S4 Accept "am" aswell as "AM"
- Review docs section 16.4

001 txtDate_Validate(
002 txtDate.value = ucase(txtDate.value)
003 )

[10 Mar 2009 12:20] Susanne Ebrecht

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. We won't add this feature request anymore.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/