MySQL Scheduled Backup does not automatically execute

"Herron, Dan" <[email protected]>
Newsgroups gmane.comp.db.mysql.windows
Message-ID <[email protected]>
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:
<?xml version="1.0"?>
<backup_profile>
  <version>1.2</version>
  <profile_name>Ggrip Database Backup</profile_name>
  <last_used></last_used>
  <options>460</options>
  <backup_type>0</backup_type>
  <entities>
    <entity>
      <name>activities</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>activitytypes</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>associates</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>associatesinoutstatus</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>associateslogonoff</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>bc</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>blobs</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>chronology</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>datebookupdates</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>leads</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>origins</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>projects</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>reasons</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>selectionschosen</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>selectionslist</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>status</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>statusactivities</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>upcards</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
    <entity>
      <name>ups</name>
      <schema>ggripdb</schema>
      <catalog>def</catalog>
      <entity_type>table</entity_type>
    </entity>
  </entities>
</backup_profile>

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:
<?xml version="1.0"?>
<user_connections>
  <last_connection>0</last_connection>
  <password_storage_type>3</password_storage_type>
  <user_connection>
    <connection_name>MySQL 4.1.12a</connection_name>
    <username>xxxxx</username>
    <hostname>Host2</hostname>
    <port>3306</port>
    <schema></schema>
    <advanced_options/>
    <storage_path></storage_path>
    <notes></notes>
    <connection_type>0</connection_type>
    <storage_type>1</storage_type>
    <password>xxxxxxxxxxxx</password>
  </user_connection>
  <user_connection>
    <connection_name>Backup Task</connection_name>
    <username>xxxxx</username>
    <hostname>Host2</hostname>
    <port>3306</port>
    <schema>ggripdb</schema>
    <advanced_options/>
    <storage_path></storage_path>
    <notes></notes>
    <connection_type>0</connection_type>
    <storage_type>1</storage_type>
    <password>xxxxxxxxxxxx</password>
  </user_connection>
</user_connections>

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
<mailto:[email protected]>


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.