Re: Newbie Question: mysqldump via PHP

Did u mention the database name from where the table has to be picked up. check out the manual for correct syntax. /sagar ----- Original Message ----- From: Tony Frasketi <webmaster@spacecovers.com> To: <php-general@lists.php.net> Sent: Tuesday, September 04, 2001 11:25 PM 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 _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com