MySQL Forums
Forum List  »  MySQL Administrator

Re: Can't Schedule Backup in MySQL admin tool
Posted by: Barry Galbraith
Date: July 16, 2009 05:28AM

OK.

Build a backup project. Schedule your job with MySQL Administrator.

Now, open Control Panel | Scheduled Tasks.

Is your backup job there?

If it is, right click and select properties.
On the Task tab, check that "Enabled" is checked.
In "Run as", check that the correct Windows username to run the task is shown.
Click on Set password, and enter the Windows password to match the Windows user that will run the task.
Save the Scheduled job.
When it's saved correctly, open the Scheduled tasks again, right click your job, and select "Run".

Does your job run? The result of the Run will be in Event Viewer.

The password for the scheduled job is the Windows user password, not the mysql user password.

The mysql user and password is set in the stored connection built with mysql administrator on Tools | Manage Connections.

Good luck.

Options: ReplyQuote


Subject
Written By
Posted
Re: Can't Schedule Backup in MySQL admin tool
July 16, 2009 05:28AM


Sorry, you can't reply to this topic. It has been closed.

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.