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" <[email protected]>
> Date: 2006/05/17 Wed AM 11:17:19 EDT
> To: <[email protected]>
> 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:
> <?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]
> 
> 


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]