Are you running on a Linux platform?
File => .my.cnf
Location => ~
Contents =>
line one: [client]
line two: user=userName
line three: password=userPassword
Security => chmod 600 .my.cnf
-----Original Message-----
From: patrick kuah [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 9:33 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: mysqldump query
Hi Victor,
Sorry...I'm not a SQL guy. Can advise me how to i procced with this???
Thanks :)
>From: Victor Pendleton <[EMAIL PROTECTED]>
>To: 'patrick kuah' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>Subject: RE: mysqldump query
>Date: Mon, 17 Nov 2003 07:06:18 -0600
>
>you could put the password in your .my.cnf file and change permissions so
>that only the MySQL user can read the file.
>
>-----Original Message-----
>From: patrick kuah [mailto:[EMAIL PROTECTED]
>Sent: Monday, November 17, 2003 5:15 AM
>To: [EMAIL PROTECTED]
>Subject: mysqldump query
>
>
>Hi guys,
>
>I have configure a daily backup for mysql database. the problem is that i
>need to specifiy the password when using mysql....
>
>mysqldump --all-databases --opt --password=1234567 >testing.sql
>
>how can i encypt this --password=1234567 ????
>Thanks
>
>patrick
>
>_________________________________________________________________
>Keep track of Singapore & Malaysia stock prices.
>http://www.msn.com.sg/money/
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
>http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Download games, logos, wallpapers and lots more at MSN Mobile!
http://www.msn.com.sg/mobile/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
