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

[17 Nov 2005 11:53] Paolo Musico'
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.
[17 Nov 2005 12:29] Paolo Musico'
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!
[9 Jan 2006 16:01] Sathaporn Nitithamyong
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 !
[29 Nov 2006 11:32] [ name withheld ]
It is necessary to put uid and pwd from existing account to get Backup-Schedule running. Trying workaround has not work!

Best Regards

Khan
[25 Oct 2008 4:56] alf gabry
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...

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.066 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.