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=3D"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=3D"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:dherron [at] kittles.com>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32 [at] m.gmane.org
