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]
