On Wed, Jul 06, 2005 at 03:08:58PM +0100, Kenn Humborg wrote:
>> I want to backup a MySQL database. So, I'll be creating
> a backup user that has global SELECT permission and whatever
> else is needed to run
>> mysqldump -u backup -p=BLAH --all-databases --opt > dump.sql
>> However, how do I avoid putting the password on the command line
> where it will be visible to anyone running ps awx?
Create ~/.my.cnf with contents like so:
[client]
host = localhost
user = backup_user
# This is the plaintext password.
password = foo
Works like a charm. You can also use --defaults-file=/some/where if
using ~/.my.cnf would obstruct other operations.
--
John Tobin
"It used to be said [...] that AIX looks like one space alien discovered
Unix, and described it to another different space alien who then
implemented AIX. But their universal translators were broken and they'd
had to gesture a lot." -- Paul Tomblin
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
