RE: [PHP] Newbie Question: mysqldump via PHP

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