Posted by strawberry on 08/22/06 08:04

J.O. Aho wrote:
> rhys@biznz.net wrote:
> > I am trying to create a one click backup database script so non-geek
> > office staff can do backups, but so far I can only output empty files -
> > the new file appears, but it is empty....
> >
> > E.G.
> > $db_user = "root";
> > $db_password = "";
> > $db_database = "or";
> > $db_server = "localhost";
> > $backup_path = "C:\\xampp\\htdocs\\openreal\\admin\\backup\\";
> > $path_to_mysqldump = "C:\\xampp\\mysql\\bin\\";
> > $filename = "backup".date("YmdHis").".sql";
> >
> > shell_exec ("mysqldump $db_database > $path_to_mysqldump.$filename
> > --user=$db_user --password=$db_password");
> >
> > I have tried various forms of this syntax with no content output?
>

...and IF that really is your password and/or directory tree, please
modify them!
> Don't think microsofts qdos supports stream redirections and I don't think you
> want a dot as the first in the filename.
>
> try
>
> shell_exec ("mysqldump $db_database --result-file=$path_to_mysqldump$filename
> --user=$db_user --password=$db_password");
>
>
> //Aho

[Back to original message]