Re: Newbie Question: mysqldump via PHP

Hi sagar The $xarray,$status parameters are part of the PHP exec command not the embedded mysqldump command. $result = exec("mysqldump -umyname --password=mypassword databsename >db.dump",$xarray,$status); Thanks, Tony sagar wrote: > > did u got it or not ? > recently i used the mysqldump. > > the syntax is as used by me is > > mysqldump [OPTIONS] database [tables] > (destination file); > > i dont know why used $xarray,$status. > > hope u'll clear out > > /sagar > > ----- Original Message ----- > From: Tony Frasketi <webmaster@spacecovers.com> > To: sagar <sagarphp@yahoo.com> > Cc: <php-general@lists.php.net> > Sent: Tuesday, September 04, 2001 11:53 PM > Subject: Re: [PHP] Newbie Question: mysqldump via PHP > > > Hi Sagar > > My goof in the email composition! 'tablename' should have been > > 'dbname'. > > So yes, the database name is specified and I am attempting to dump the > > entire database with all tables. > > > > Thanks for point out my error. > > > > sagar wrote: > > > > > > 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 > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com