Reply to Re: mysql dump creates empty file

Your name:

Reply:


Posted by vesakilp on 09/10/06 18:32

vesakilp@gmail.com kirjoitti:

> vesakilp@gmail.com kirjoitti:
>
> > J.O. Aho kirjoitti:
> >
> > > vesakilp@gmail.com wrote:
> > > > J.O. Aho kirjoitti:
> > >
> > > >>> So there wasn't any out put from $error_message. File was still
> > > >>> created, but it was empty. Starting to piss me off.
> > > >>> By the way, same mysqldump script works fine when executed in console.
> > > >> You haven't disabled shell_exec() in your php.ini for the Apache or in your
> > > >> Apache configurations VirtualHost tag?
> > > > Not intentionally, at least... How can I check that?
> > >
> > > grep for disable_functions in your php.ini (noticed that this one can't be set
> > > in the apache config file as other like open_basedir).
> > >
> > >
> > > //Aho
> >
> > did that, still gives empty file
>
> allthought i'm not quite sure that I did what you asked me to, I just
> put ; in front of disable_functions line in php.ini, don't really know
> what's that grepping you're talking about, might have something to do
> with linux shell but I'm using XP....

Solved it!!! I had to put the directory, where mysqldump command is, in
string that was executed:

$backup = "c:\wamp\mysql\bin\mysqldump -hlocalhost -u$duser -p$dpass
$dbase table_name > backup/table_name.sql";
shell_exec($backup);

In windows shell, command has to be driven from the directory where it
is, of course, so simple. But how can I make it work on Unix server....?

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация