Description:
Having setup scheduled backups on our dbs, I have found a few things and worked through some. However, I have now got to a point from which I can progress no further. The scheduled task setup by MySQL Administrator does not work and reports the following error:
Event Type: Error
Event Source: Application Error
Event Category: (100)
Event ID: 1000
Date: 26/09/2005
Time: 23:33:20
User: N/A
Computer: DERBYDC
Description:
Faulting application MySQLAdministrator.exe, version 1.1.1.0, faulting module libmysqladmin.dll, version 0.0.0.0, fault address 0x00005921.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74 Applicat
0008: 69 6f 6e 20 46 61 69 6c ion Fail
0010: 75 72 65 20 20 4d 79 53 ure MyS
0018: 51 4c 41 64 6d 69 6e 69 QLAdmini
0020: 73 74 72 61 74 6f 72 2e strator.
0028: 65 78 65 20 31 2e 31 2e exe 1.1.
0030: 31 2e 30 20 69 6e 20 6c 1.0 in l
0038: 69 62 6d 79 73 71 6c 61 ibmysqla
0040: 64 6d 69 6e 2e 64 6c 6c dmin.dll
0048: 20 30 2e 30 2e 30 2e 30 0.0.0.0
0050: 20 61 74 20 6f 66 66 73 at offs
0058: 65 74 20 30 30 30 30 35 et 00005
0060: 39 32 31 921
I was having an issue with a different error beforehand, but found some documentation regarding creating a profile in MySQL Administrator for connecting and now this has brought me to this point.
A few other points to note are as follows. We have 4 MySQL dbs running on the server the mysqldb, two bugzilla dbs and a mediawiki db. I can "sometimes" run a backup manually on two of them (one bugzilla and the mediawiki) by using the Execute Backup Now function in MySQL Administrator, however this only works once per try and will not execute again if it does work until logging on again and trying again and then sometimes it works sometimes it does. I am using the server administrator account to execute the backups and the administrator has full rights to the backup directory on the local machine. The other two dbs, simply write 0Kb files when a backup is executed manually and have never worked. The scheduled tasks created using MySQL Administrator are all scheduled an hour apart and have never worked at all on any of the four dbs.
I am using Terminal Services to configure MySQL Administrator and I logon with the administrator account, the scheduled tasks also use the administrator account to run and the advanced log shows the following exit code:
"Bugs_Database.job" (MySQLAdministrator.exe)
Started 26/09/2005 23:33:17
"Bugs_Database.job" (MySQLAdministrator.exe)
Finished 26/09/2005 23:33:20
Result: The task completed with an exit code of (c0000005).
How to repeat:
Create a backup schedule as follows:
• Create directory D:\backup
• Create directory D:\backup\bugs_db
• Open MySQL Administrator (login as root) (save profile as Backup)
• Click on Backup on the left pane and then click New Project
• In Project Name enter Bugs_Database
• In the Schemata pane click bugs and then click the > button
• The bugs database should be in the Backup Content pane now and ticked
• Click on Advanced Options tab
• Backup Execution Method – select InnoDB Online Backup and tick Complete Backup
• Backup Type > SQL Files and have the following ticked:
o Add DROP Statement
o Complete INSERTs
o Comment
o Disable Keys
• Click on Schedule tab
• Tick Schedule this backup project – this pops up a box regarding pasword storage, click Open Options
• Click on General Options in the left hand pane
• Tick Store Password and select Obscured in the Password Storage Method combo box
• Click Apply and click Close
• In Target folder enter D:\backup\bugs_db
• Filename = bugs_db
• Execute backup daily and select all the days Monday thru Sunday
• Execution Time = 00:00
• Save Project
• Enter the administrator password
