MySQL Forums :: Backup :: Running backup in cron without clear text pw

Advanced Search

Running backup in cron without clear text pw
Posted by: Lee Murray ()
Date: December 11, 2012 04:53PM

I am a long time Oracle DBA just now getting involved in supporting MySQL. I am use to in the Oracle RDBMS world on Unix of being able to run RMAN backups via script in cron where connection to the database can be made via "/ as sysdba" (or more correctly "rman target /") when running under the "oracle" Unix account not requiring an embedded clear text password. With MySQL and using the standard mysqldump it appears the best one can do is put username/pw of the user used for backup in the my.cnf file under [mysqldump] and set permissions to 600 for that file. Am I missing anything? Are there other backup tool options like MEB or XtraBackup that would provide a means to not reveal a password in clear text for the backup user? What would the gurus on this forum suggest for a production system?

My first system will be fairly small single MySQL database using the MyISAM engine. It does not get used (or will not) after business hours. Thanks in advance for your help.

Options: ReplyQuote

Subject Views Written By Posted
Running backup in cron without clear text pw 1922 Lee Murray 12/11/2012 04:53PM
Re: Running backup in cron without clear text pw 1181 Rick James 12/23/2012 10:21AM

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.