MySQL Forums
Forum List  »  MySQL Administrator

Re: cannot create new backup task
Posted by: Captoon Caricature
Date: January 11, 2012 11:10AM

Do not use MySQL Administrator for backup
It isn’t well designed ! Looks attractiv at first, but it isn’t realy for production use. So keep your backup script.
I loose 2 hours, trying to use MySQL Administrator on Windows, because don’t know a lot about scripting in Windows. So you create a backup project and MySQL Administrator creates :

a windows’s “Scheduled Task”. It ask you which windows user you want to use.
a project_name.mbp : the backup definition
a mysqlx_user_connections.xml : the MySQL users definitions
Problem is : the 2 files are created in C:\Documents and Settings\[user]\Application Data\MySQL !
Big problem is the MySQL users file is used by MySQL Administrator and
MySQL Query. Passwords have to be recorded in the file and you don’t really know wich user will perform the backup !
They really should put the MySQL user/password in the backup project and put the project file in the MySQL data directory.

Options: ReplyQuote

Written By
November 28, 2011 11:47AM
Re: cannot create new backup task
January 11, 2012 11:10AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.