Re: Newbie Question: mysqldump via PHP

the unix command to see where an executable is, is which. Example: "which mysqldump" ----- Original Message ----- From: "Tony Frasketi" <webmaster@spacecovers.com> To: "Sam Masiello" <smasiello@synacor.com> Cc: <php-general@lists.php.net> Sent: Tuesday, September 04, 2001 11:53 AM 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 > > smasiello@synacor.com > > > > -----Original Message----- > > From: Tony Frasketi [mailto:webmaster@spacecovers.com] > > Sent: Tuesday, September 04, 2001 2:28 PM > > To: Sam Masiello > > Cc: php-general@lists.php.net > > 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 > > > smasiello@synacor.com > > > > > > -----Original Message----- > > > From: Tony Frasketi [mailto:webmaster@spacecovers.com] > > > Sent: Tuesday, September 04, 2001 1:56 PM > > > To: php-general@lists.php.net > > > 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: php-general-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-general-help@lists.php.net > > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >