> "ParazaR" <parazar@nowhere.com> wrote in message
> news:43a69094$0$18341$8fcfb975@news.wanadoo.fr...
>> I use MySQL Administrator for MySQL database backup but if the manual
>> backup it's ok, the sheduler backup does't work. There are no warning
>> message and the sheduled task are ok !
>> Have you idear ?
Okay, I've tried it myself on Windows XP (I'll assume you're on Windows
too).
I saw that the job failed to run at the time I specified, with no obvious
log information.
I found How to Troubleshoot Scheduled Tasks in Windows XP:
http://support.microsoft.com/default...b;en-us;308558
Note it tells you to look at C:\Windows\Sschedlgu.txt, which is a text log
file for the Windows Scheduler. Reading that file on my system, I see the
following:
"Test.job" (MySQLAdministrator.exe) 12/19/2005 11:00:00 AM ** 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.
Googling for the error message in the last line of that log, I found this
Microsoft support page:
http://support.microsoft.com/default...b;en-us;884573
The cause is apparently a "regression" (i.e. a bug) introduced by Windows XP
SP2. It sounds like they tried to resolve a security vulnerability in Task
Scheduler, and succeeded in breaking it further!
They give some workarounds in that support article. I'm using XP Pro SP2,
so I tried to follow the workaround instructions on my system, but so far it
has not succeeded in producing a scheduled backup.
Has anyone else have any luck getting MySQL Backup scheduling to work on XP
SP2?
Regards,
Bill K.