View Single Post

   
  #3 (permalink)  
Old 02-28-2008, 07:13 AM
Bill Karwin
 
Posts: n/a
Default Re: MySQL Administrator Sheduler backup !

> "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.


Reply With Quote