I just tried to use MySQL Administrator to make a scheduled backup. As instructed, I created a backup project and saved the connection info.
Using the GUI the Backup worked, but executing the command line (that is run with Scheduled Tasks) didn’t work. It simply log the following to the event log:
Can't connect to MySQL server on 'localhost' (10061) (Error 2003).
I looked at the command it generates and couldn’t find an error:
"C:\Program Files\MySQL\MySQL Tools for 5.0\MySQLAdministrator.exe" "-UDC:\Documents and Settings\Administrator.ACME\Application Data\MySQL\" "-cROOT-LOCAL" "-bpFullBackup" "-btD:\MySQL5\backup\" "-bxFullBackup"
Until I realized that the extra “-“ inside my saved connection “ROOT-LOCAL” might confuse MySQL Administrator. I renamed this connection info to "ROOTLOCAL" and change the parameter in the command line: Bingo, everything is working.
Great, even today argument parsers are causing trouble…
You can use dbForge Studio for MySQL http://www.devart.com/dbforge/mysql/studio/ instead of MySQL Administrator. Studio is much more functional and professional management software!
ReplyDelete