Re: Newbie Question: mysqldump via PHP
| From: | Tony Frasketi | Date: | Tue, 04 Sep 2001 18:23:08 +0000 |
| Subject: | Re: Newbie Question: mysqldump via PHP | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-65917@lists.php.net to get a copy of this message | ||
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