ruby script to enter prompt command from a system command

I'm trying to write a simple script to mysqldump some dbs. I'm getting stuck on the password prompt though.

I'd like to just have a config file that contains all the db creds, then the script can use those to connect to the db.

Problem is a command such as:

system('mysqldump -u username -p')

then prompts for

Enter password:

even when I do something like:

system('mysqldump -u username -p some_password')

I still get prompted for the password...

I don't do a whole lot 开发者_高级运维of scripting in Ruby so I'm at a loss as to how my script can automatically enter this info so the user running the script doesn't have to.

---

If you already know the password why aren't you passing it to the command?

system('mysqldump -u username --password=mypassword')

---

you need to delete space after -p

system('mysqldump -uusername -psome_password')

or without password just

system('mysqldump -uusername')

or

system('mysqldump -uusername --password=')

---

you could always check the application that uses the database for the password, check the config file file for the connection string. Failing that change the password in the database.