MySqldump creates empty file

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?

Re: MySqldump creates empty file

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?

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

Re: MySqldump creates empty file

> Don't think microsofts qdos supports stream redirections and I don't think you
> want a dot as the first in the filename.

Thanks for the reply - What is qdos?

I am trying to do this with php code, but don't really know what I'm
doing............
This is to run under an existing php program

Re: MySqldump creates empty file

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

Re: MySqldump creates empty file

rhys@biznz.net wrote:
>> Don't think microsofts qdos supports stream redirections and I don't think you
>> want a dot as the first in the filename.
>
> Thanks for the reply - What is qdos?

'Quick and Dirty Operating System' (qdos) is what MS-Dos is.


//Aho

Re: MySqldump creates empty file

OK - solved that. This works"-

$fish= "$path_to_mysqldump\\mysqldump.exe --u $db_user
--ignore-table=$db.$config $db > $filename ";
exec($fish);