MySQL Bugs: #19514: Scheduled Backup on XP SP2 does not work

Bug #19514	Scheduled Backup on XP SP2 does not work - fix suggested
Submitted:	3 May 2006 12:24	Modified:	28 Aug 2006 10:22
Reporter:	Adrian Unsworth	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.1.9	OS:	Windows (XP SP2, Fedora Core 4)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Backup

Description:
Creating a scheduled backup via MYSQL Administrator, creates a schedule entry in Windows Scheduled tasks that is unable to exectue.

How to repeat:
Install MYSQL and Administrator. Create a scheduled backup. Wait for execution...

Suggested fix:
It appears that XP (SP2 in this case) has an issue with registering user account information in the scheduled tasks security database. For me, the fix was to edit the properties of the windows scheduled task that is created by MYSQL Administrator and manually set the password for your given user account information (that you provided when saving the scheduled backup in MYSQL Adminstrator) via the 'set password' tab. Then the scheduled backup/s run OK...

Hope this helps...

Thank you for the bug report. Could you please provide the message
printed in the Event Viewer for MySQL Administration when the backup
schedule failed?

Thanks in advance.

Error in SchedLgU.Txt:

The attempt to retrieve account information for the specified task failed; therefore, the task did not run. Either an error occurred, or no account information existed for the task.
The specific error is:
0x8004130f: No account information could be found in the Task Scheduler security database for the task indicated.

Thank you for the bug report.

There is same bug on Fedora Core 4: http://bugs.mysql.com/bug.php?id=20250&thanks=1&notify=7

I tried the solution on this posting, it doesnt work for my case.

Can anyone send me a detailed solution to solve this bug?

In Windows, go to Control Panel->Scheduled Tasks

There should be a task in there that has the same name of the backup task that you created within the MySQL administrator. Right click it and select properties. In there you will see a Set Password button. Click that and insert the password. I believe the problem is that the password is not being set. 

HTH

Another duplicate: #20779.

I have the same problem under FC4.  I believe it's a dependancy change of some sort.  Remi Collet did a patch sometime back that did work but for the latest version of FC4 it doesn't work..... have no clue here what's wrong !

There might be a fix for windows here:

http://rpm.pbone.net/index.php3/stat/4/idpl/2850581/com/mysql-administrator-1.1.10-1.fc4.r...

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html