MySQL Bugs: #12579: Sheduled backup tasks fail to create a backup

Bug #12579	Sheduled backup tasks fail to create a backup
Submitted:	15 Aug 2005 10:04	Modified:	26 Aug 2005 18:35
Reporter:	Adrian Marsh	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.1.1 RC	OS:	Any (2000 AS)
Assigned to:		CPU Architecture:	Any

Description:
I have no problem creating the backup in the administrator. I define the schedule using a Domain Admin account (so no security issues).

Logged in as the same account, I can manually run the job, and get a resulting backup.

In the windows Scheduler, the backup seems to run (last run time changes, with an error code of 0), but no backup file is produced.

I've tried removing the backup and re-creating but it still occurs.

mySQL is installed on another server. The Administrator is on SWODELL04, and the SQL server is on SWOCMPQ04.   SWODELL04 is our admin/backup machine so needs to run here.  Both machines are part of a 2000 AD Domain.

Below is scheduled task cmd :

"C:\Program Files\MySQL\MySQL Administrator 1.1\MySQLAdministrator.exe" "-UDC:\Documents and Settings\labadmin.UK-LAB\Application Data\MySQL\" "-c" "-bpBackups" "-btC:\backups\mysql_on_swocmpq04\" "-bxBackups"

How to repeat:
For me:   Simply setup a backup as normal, and schedule it.

Hi!

I can't reproduce this problem.  Is there any other information you can give us that might help us repeat this bug ?

Thanks!

I'm not sure.  Everything else in SQL Administrator works ok, and if I run the backup from within the GUI it works ok.

I'm seeing this same issue with 1.1.1 RC. (OS: Win2.3K SP 1) and the schedule backup creator. It creates this a task with this info:

Run:

"C:\Program Files\MySQL\MySQL Administrator 1.0\MySQLAdministrator.exe" "-UDC:\Documents and Settings\Administrator\Application Data\MySQL\" "-c" "-bpFreund_DBs" "-btE:\Backups\mySQL\All_DBs\" "-bxFreund_DBs"

Start In:

"C:\Documents and Settings\Administrator\Application Data\MySQL\"

But fails to execute at the requested time, or if manually started via the Scheduled Tasks. Even the mySQL Administrator GUI fails to run the Backup correctly. Click the Execute Backup now and it creates a 0 byte file and locks that file - doing nothing else.

The Windows Event Manager says this, when I attempt to run the Scheduled Task manually:

Event Type:	Error
Event Source:	MySQL Administrator
Event Category:	None
Event ID:	1
Date:		8/19/2005
Time:		11:39:55 PM
User:		N/A
Computer:	WWW
Description:
Connection -bpFreund_DBs cannot be found.

There is no error reported for the GUI executing the backup.

When I view the directory that holds the Freund_DBs backup control file only a Freund_DBs.mbp file exists. Should there be another? 

I've just upgraded the mySQL DB to version 4.1.13a-nt and to mySQL Administrator 1.1.1 RC - now no backups. ;-( 

If you need anything else - please let me know.

Well.. Mine does work manually but checking the event logs, I see two entries at the scheduled task time.  1 warning and 1 error.  The backup project name is "Backups". From the error message though it can't find it..

Event Type:	Information
Event Source:	MySQL Administrator
Event Category:	None
Event ID:	1
Date:		20/08/2005
Time:		11:14:05
User:		N/A
Computer:	SWODELL04
Description:
The description for Event ID ( 1 ) in Source ( MySQL Administrator ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: MySQL Administrator is preparing backup for profile Backups..

and

Event Type:	Error
Event Source:	MySQL Administrator
Event Category:	None
Event ID:	1
Date:		20/08/2005
Time:		11:14:05
User:		N/A
Computer:	SWODELL04
Description:
The description for Event ID ( 1 ) in Source ( MySQL Administrator ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: Connection -bpBackups cannot be found..

Why has this been closed?  Two users with a similar problem and we don't even investigate it ???

I changes the "-c" to "-C" and now my backups work with the Microsoft sched...Windows 2003 small business server...   I don't know what the -c is supposed to do....

I'm looking for some kind of reference on all the swiches for mysqladministrator....I guess I could look at a Linux installation, but that means I would have to do one....does anyone out there know where I can get a mysqladministrator man page on-line or something?