You are here: Re: backing up mysql question « All PHP « IT news, forums, messages
Re: backing up mysql question

Posted by anonymous on 08/13/07 21:55

On Aug 13, 4:43 pm, Rik <luiheidsgoe...@hotmail.com> wrote:
> On Mon, 13 Aug 2007 23:40:33 +0200, <@gmail.com> wrote:
> > Hi,
> >> <?php
>
> >> $username = 'YOURUSERNAME';
> >> $password = 'YOURPASSWORD';
> >> $database = 'DATABASENAME';
> >> $filename = 'FILENAME';
>
> >> system("mysqldump --compact --compress -u{$username} -p{$password}
>
> >> > {$database} | gzip --best > {$filename}");
>
> >> ?>
>
> > I ran this,
>
> > <?php
>
> > $username = 'logg1';
> > $password = 'something';
> > $database = 'dbplace';
> > $filename = 'testing.zip';
>
> > system("mysqldump --compact --compress -u{$username} -p{$password} >
> > {$database} | gzip --best > {$filename}");
>
> > ?>
>
> > It placed a 'testing.zip' in the root folder, however it was only 20
> > bytes and nothing was in it. I know I have the other settings right
> > as I use it successfully elsewhere. There were no displayed errors
> > after running it, ... is there anything I can do to de-bug? :) :)
>
> Give a FULL path to the file (like: /etc/path/to/file.zip). And enable
> errors:
> <?php
> ini_set('display_errors',1);
> error_reporting(E_ALL);
> system();//etc
> ?>
>
> --
> Rik Wasmus

Hi Rik!
Well, I used the full path and it totally didn't work with that. Since
it's placing something, or attempting to generate a zip file, I
presume that path is fine the way I had it.

Also, the error didn't help, I am getting an error on the error
checking :))

<?php
ini_set('display_errors',1);
error_reporting(E_ALL);
system();//etc
?>
Warning: Wrong parameter count for system() in /usr/home/domain/
www.domain.com/www/backup.wave on line 19

 

Navigation:

[Reply to this 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

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