Posted by Michael on 09/08/06 19:52

"There is no option for password, beucause of security reasons"
Wrong, I have an automated backup script (powered by PHP) and it uses
the mysqldump terminal command and you can specify password (because I
do). The poster above you was correct (the poster called NC).
Mateusz Markowski wrote:

> Noodle napisal(a):
> > Hi,
> >
> > I want to dump out a database to the screen using mysqldump, like so...
> >
> > <?php
> > echo system('mysqldump -h localhost -u user -p password
> > my_database');
> > ?>
> >
> > However, it won't accept my password being passed in like this. Is this
> > a mysql configuration problem?
>
> No, just take a look at mysqldump manpage. There is no option for
> password, beucause of security reasons. If it was possible, everyone
> would see your password by typing just: $ps -aux.
>
> Maybe try to open pipe to mysqldump proccess and then put password into
> it. (php.net/popen)

[Back to original message]