sudo mysqldump --defaults-extra-file="~root/.my.cnf" ...
Automatic MySQL Backup
Brought to you by:
wipe_out
I have a ".my.cnf" setup that holds my root login for mysql related
commands, this aleviates me from remembering
and does not expose the password in the process execution.
sudo mysqldump --defaults-extra-file="~root/.my.cnf" ...
Example: marco@srv42:/etc/automysqlbackup$ sudo cat /root/.my.cnf
[client]
user=root
pass=xyzabc123
My feature request is to have an
option for "--defaults-extra-file" instead of user/password
I would also like this feature added. It could be yet another config in the different levels of configuration files.
+1
Don't like having the root mysql password littered about everywhere
I created a patch that provides a workaround for this. See ticket #29 in Patches.
https://sourceforge.net/p/automysqlbackup/patches/29/
Last edit: Jim Cooley 2013-08-08