Have you tried storing the mysqldump output to a string and then using PHP
to open a file, dump the string into the file, and then close the file?
Might work that way...
----- Original Message -----
From: "Tony Frasketi" <[EMAIL PROTECTED]>
To: "Sam Masiello" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, September 04, 2001 12:39 PM
Subject: Re: [PHP] Newbie Question: mysqldump via PHP
> Hi Sam
> Thanks to suggestions from jason, Alexander, and yourself I tried the
> unix which command and found that mysqldump was located at...
>
> /usr/bin/ directory
>
> And I changed my exec command to include this directory but alas, the
> results were the same.
>
> Is it possible that the mysqldump command cannot be run from PHP under
> user nobody?
>
> Still appreciative of any other ideas I can try!
> Tony F.
>
> 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]
>
>
--
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]
