MySQL Bugs: #15012: Schedule backup doesn't work

Bug #15012	Schedule backup doesn't work
Submitted:	17 Nov 2005 11:53	Modified:	17 Nov 2005 12:29
Reporter:	Paolo Musico'	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	v1.1.5 with MySQL 5.0.15	OS:	Windows (Windows 2003 without SP1)
Assigned to:		CPU Architecture:	Any

Description:
Hi,

I created a scheduled backup project and it does not work.
If you choose "Execute Backup Now" the job works fine.
Only the scheduled part fails.

First test
When I saved the scheduled backup i inserted the windows user.

ERROR
I open the Schedlgu.txt file in the Windows folder:
"Backup MY DB.job" (MySQLAdministrator.exe) 16/11/2005 20:33:21 ** ERROR **
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.

Second test
I defined the MySQL user on windows.
When I saved the scheduled backup i inserted the mysql user.

ERROR
I open the Schedlgu.txt file in the Windows folder:
"Backup MY DB.job" (MySQLAdministrator.exe) 16/11/2005 21:55:44 ** ADVISE **
Working Directory does not exist..
Specified Error is:
0x00000005: Access denied.
Verify that the directory exists and retry..

How to repeat:
First Test
From Administrator Backup
1) Configure a New Backup Project
2) Choose the Schedule this backup project
3) At save when it asks for the user, I am using a WINDOWS user.

Second Test
From Administrator Backup
1) Configure a New Backup Project
2) Choose the Schedule this backup project
3) At save when it asks for the user, I am using a MYSQL user.

Suggested fix:
Microsoft suggest to install service pack 1 to solve this problem.

I solved the problem!
I create the user root on windows and the same user for MySQL Server.
Then i schedule the backup saving it with the the user root.
Now the backup works!

I just found a workaround !

Let's open options window and go to Connections page. You need to use connection under "Connections" node, not "History" node. Add a new connection and use it, now scheduled backup will work !

It is necessary to put uid and pwd from existing account to get Backup-Schedule running. Trying workaround has not work!

Best Regards

Khan

For me the problem was that I did not understant that the user must be a Windows user, in fact, it is asked for "Enter user name and password for the account". Which account? Mysql account? Mysql admin? No, just Windows account...