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]
