MySQL Scheduled Backup does not automatically execute

Versions
Win2K v5.0 (Build 2195 SP4)
MySQL v4.1.12a-nt
MySQL Administrator v1.1.9

I have setup a scheduled backup task thru the Backup tab of MySQL =
Administrator, but the task never executes at the appointed time.
The scheduled task always shows a STATUS of "Could not start".
If I execute the backup manually thru MySQL Administrator it works fine.

Here is the contents of the backup MBP file:


1.2
Ggrip Database Backup

460
0


activities
ggripdb
def
table


activitytypes
ggripdb
def
table


associates
ggripdb
def
table


associatesinoutstatus
ggripdb
def
table


associateslogonoff
ggripdb
def
table


bc
ggripdb
def
table


blobs
ggripdb
def
table


chronology
ggripdb
def
table


datebookupdates
ggripdb
def
table


leads
ggripdb
def
table


origins
ggripdb
def
table


projects
ggripdb
def
table


reasons
ggripdb
def
table


selectionschosen
ggripdb
def
table


selectionslist
ggripdb
def
table


status
ggripdb
def
table


statusactivities
ggripdb
def
table


upcards
ggripdb
def
table


ups
ggripdb
def
table




Here is the MySQL connections file(I have obfuscated any userids or =
passwords with x's for the sake of security).
I know the "Back Task" connection works because I have used it to login =
thru MySQL Administrator:


0
3

MySQL 4.1.12a
xxxxx
Host2
3306




0
1
xxxxxxxxxxxx


Backup Task
xxxxx
Host2
3306
ggripdb



0
1
xxxxxxxxxxxx



Here are the scheduled task particulars:
Run: "C:\Program Files\MySQL\MySQL Administrator =
1.1\MySQLAdministrator.exe" "-UDC:\Documents and =
Settings\Administrator.KITTLES\Application Data\MySQL\" "-cBackup Task" =
"-bpGgrip Database Backup" "-btI:\BACKUP\Ggrip\" "-bxGgrip Database =
Backup"
Start in: "C:\Documents and Settings\Administrator.KITTLES\Application =
Data\MySQL\"
Run as: Host2\administrator


Dan Herron
Sr. Programmer/Analyst/DBA/EDI Administrator
Kittles Home Furnishings
Indianapolis, Indiana
(317) 558-4577



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: MySQL Scheduled Backup does not automatically execute

We had the same issue when it issetup with the MySQL Administrator. We had to update the windows scheduler with the user and password before it worked.

From the Scheduled Task screen, you can view the log (Advanced -> View Log) to help determine the reason why the schedule did not run.

Regards.

>
> From: "Herron, Dan"
> Date: 2006/05/17 Wed AM 11:17:19 EDT
> To:
> Subject: MySQL Scheduled Backup does not automatically execute
>
> Versions
> Win2K v5.0 (Build 2195 SP4)
> MySQL v4.1.12a-nt
> MySQL Administrator v1.1.9
>
> I have setup a scheduled backup task thru the Backup tab of MySQL Administrator, but the task never executes at the appointed time.
> The scheduled task always shows a STATUS of "Could not start".
> If I execute the backup manually thru MySQL Administrator it works fine.
>
> Here is the contents of the backup MBP file:
>
>
> 1.2
> Ggrip Database Backup
>
> 460
> 0
>
>
> activities
> ggripdb
> def
> table
>
>
> activitytypes
> ggripdb
> def
> table
>
>
> associates
> ggripdb
> def
> table
>
>
> associatesinoutstatus
> ggripdb
> def
> table
>
>
> associateslogonoff
> ggripdb
> def
> table
>
>
> bc
> ggripdb
> def
> table
>
>
> blobs
> ggripdb
> def
> table
>
>
> chronology
> ggripdb
> def
> table
>
>
> datebookupdates
> ggripdb
> def
> table
>
>
> leads
> ggripdb
> def
> table
>
>
> origins
> ggripdb
> def
> table
>
>
> projects
> ggripdb
> def
> table
>
>
> reasons
> ggripdb
> def
> table
>
>
> selectionschosen
> ggripdb
> def
> table
>
>
> selectionslist
> ggripdb
> def
> table
>
>
> status
> ggripdb
> def
> table
>
>
> statusactivities
> ggripdb
> def
> table
>
>
> upcards
> ggripdb
> def
> table
>
>
> ups
> ggripdb
> def
> table
>
>
>
>
> Here is the MySQL connections file(I have obfuscated any userids or passwords with x's for the sake of security).
> I know the "Back Task" connection works because I have used it to login thru MySQL Administrator:
>
>
> 0
> 3
>
> MySQL 4.1.12a
> xxxxx
> Host2
> 3306
>
>
>
>
> 0
> 1
> xxxxxxxxxxxx
>
>
> Backup Task
> xxxxx
> Host2
> 3306
> ggripdb
>
>
>
> 0
> 1
> xxxxxxxxxxxx
>
>
>
> Here are the scheduled task particulars:
> Run: "C:\Program Files\MySQL\MySQL Administrator 1.1\MySQLAdministrator.exe" "-UDC:\Documents and Settings\Administrator.KITTLES\Application Data\MySQL\" "-cBackup Task" "-bpGgrip Database Backup" "-btI:\BACKUP\Ggrip\" "-bxGgrip Database Backup"
> Start in: "C:\Documents and Settings\Administrator.KITTLES\Application Data\MySQL\"
> Run as: Host2\administrator
>
>
> Dan Herron
> Sr. Programmer/Analyst/DBA/EDI Administrator
> Kittles Home Furnishings
> Indianapolis, Indiana
> (317) 558-4577
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=bobingra@bellsouth.net
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org