Posted by: Anonymous Coward
on May 29, 2007 05:47 PM
What I forgot to mention is that with these command-line tools (mysqlhotcopy, mysqldump etc.) you pass a username and a password directly to the command. When executed, this command ends up in the processlist (try ps aux for example) with the credentials fully readable.
When your backup takes a while, this display of credentials will be up there as long as it takes. So, be cautious doing so. You better make a<nobr> <wbr></nobr>.my.cnf in the user's home directory under wich you make these backups. Place your needed credentials and parameters in there so the are kept hidden while the backup is executed and visible in the processlist.
Learn about Linux
Download Linux
Get Linux help
Re:Additionally... if I may... this is crucial
Posted by: Anonymous Coward on May 29, 2007 05:47 PMWhen your backup takes a while, this display of credentials will be up there as long as it takes. So, be cautious doing so. You better make a<nobr> <wbr></nobr>.my.cnf in the user's home directory under wich you make these backups. Place your needed credentials and parameters in there so the are kept hidden while the backup is executed and visible in the processlist.
- Unomi -
#