You could do:
"which mysqldump" (without the quotes, of course :) ).
This is provided that mysqldump is in your path (if you can enter just
"mysqldump" from the command line, then it is).
HTH
Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 X289
[EMAIL PROTECTED]
-----Original Message-----
From: Tony Frasketi [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 2:53 PM
To: Sam Masiello
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Newbie Question: mysqldump via PHP
Hi Sam
No I haven't tried this since I'm on a virtual server and don't know
where mysqldump is located. I tried doing a phpinfo() to see if I could
get the mysqldump location from there but I didn't see it in the mysql
section of the phpinfo listing. Do you know of a unix shell command I
could use to get the location of mysqldump?
Tony
Sam Masiello wrote:
>
> Have you tried putting in the fully qualified pathname to the
mysqldump
> executable?
>
> /usr/somepath/mysqldump <rest of your command here>
>
> HTH
>
> Sam Masiello
> Software Quality Assurance Engineer
> Synacor
> (716) 853-1362 X289
> [EMAIL PROTECTED]
>
> -----Original Message-----
> From: Tony Frasketi [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 04, 2001 2:28 PM
> To: Sam Masiello
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Newbie Question: mysqldump via PHP
>
> Hi Sam
> Thanks for the reply. I had the permission set for 777 so that should
> allow access to the directory for writing from PHP, should it not?
>
> Also I tried specifying >/tmp/db.dump in the command and had the tmp
> directory permission also set for 777 but still get same results. The
> file get written but it's still set to zero bytes.
>
> Any other suggestions would be greatly appreciated.
>
> Sam Masiello wrote:
> >
> > I would say that you have a permission problem with where PHP is
> trying
> > to write the file to. Try outputting the file to /tmp/db.dump and
see
> > if you have the same problem.
> >
> > HTH
> >
> > Sam Masiello
> > Software Quality Assurance Engineer
> > Synacor
> > (716) 853-1362 X289
> > [EMAIL PROTECTED]
> >
> > -----Original Message-----
> > From: Tony Frasketi [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, September 04, 2001 1:56 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] Newbie Question: mysqldump via PHP
> >
> > Hello listers
> >
> > I'm trying to implement a mySQL database dump via PHP4 on a unix
> system
> > as follows...
> >
> > ------------------------------------------------------
> > $result = exec("mysqldump -umyname --password=mypassword
> > tablename >db.dump",$xarray,$status);
> > echo "status[$status]<br>";
> > ------------------------------------------------------
> >
> > I get the following error PHP error message...
> >
> > status[127]
> >
> > and the file 'db.dump' has been created but it has 0 bytes.
> >
> > -rw-r--r-- 1 nobody nobody 0 Sep 4 13:27 db.dump
> >
> > Although I can execute the mysqldump program from the unix shell and
I
> > get...
> >
> > -rw-r--r-- 1 myname myname 23704 Sep 4 13:18 db.dump
> >
> > My questions are...
> >
> > 1. Can the mysqldump program be executed via PHP or not and if not
> > can you please explain why?
> >
> > 2. Is there another way of doing this via PHP?
> >
> > Thanks in advance
> > Tony Frasketi
> > P.S. Please answer direct, since I'm only subscribed to the digest.
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
