Cabbar Duzayak wrote:
...
I have setup cronjobs to take daily backups of my db using mysqldump.
But the problem is, mysqldump requires the password to be passed via
command line, which means anyone on the same machine can take a peek
at my password using "top", "ps -ef", etc.
Is there a way of a
ng in my case.
Anurag
-Original Message-
From: Rich Allen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 20, 2005 6:20 AM
To: Cabbar Duzayak
Cc: mysql@lists.mysql.com
Subject: Re: MySQLDump - Command line password
have you looked at using a my.cnf file?
eMac:~ hcir$ mysqldump test &g
have you looked at using a my.cnf file?
eMac:~ hcir$ mysqldump test > /temp/test.sql
eMac:~ hcir$ ls -l /temp/test.sql
-rw-r--r-- 1 hcir staff 78893008 Jul 19 16:47 /temp/test.sql
contents of ~/.my.cnf
[client]
user= username
password= password
# actual username and passw