LINUX.IE, website of the Irish Linux Users' Group
Tux rules!

   
Home
New Users
Articles
Download
Projects
Community
Vendors

  Print Version
Email to...
 
Archives:


planetILUG

Recent News

News Archive


Join the
ILUG
on FaceBook


Join the
ILUG
on LinkedIn


Join the
ILUG SETI
Group



















 
 :: Mailing Lists

[ILUG] Avoiding password on mysqldump command line

[ILUG] Avoiding password on mysqldump command line

Kenn Humborg kenn at bluetree.ie
Wed Jul 6 15:08:58 IST 2005


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?

I've tried 

   echo BLAH | mysqldump -u backup -p --all-databases ...

and 

   mysqldump -u backup -p --all-databases ... <<EOF
   BLAH
   EOF

But neither works.  It seems mysqldump wants to read from the "tty",
not from stdin.

Later,
Kenn




More information about the ILUG mailing list
Read this without the formatting.
                                                                                                    

 

Hosted by HEAnet


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!
RSS Version
Powered by Dell