Windows Executables Help

beettlle

I've been trying to make a page that can back up my MySQL DB for me. This might be realy dumb for better coders but this is how I'm trying to do it:
<?php
$db = c:\Program Files\MySQL\bin\mysqldump test
echo $db
?>
My problems comes in the fact that the "c:\Program Files\MySQL\bin\mysqldump test" command doesn't even work when I try it from the comman line. Any help on how I could get the output of the mysqldump to a file or, at least, to a webpage in a fashion simmilar to what I tried to do above? Thanks

Anon

Beettlle wrote:

does c:\Program Files\MySQL\bin\mysqldump test > test.sql
work?

moonie 😉

beettlle

The problem is that don't even get the error message in the variable(which is what happens when you don't give any arguments to 'mysqldump'). So I tried something diferent:
<?php
$cmd = "mysqldump test > big_dump.txt" ;
$puke = system($cmd) ;

$fp = fopen ("big_dump.txt", "r") ;

while ($data = fgets ($fp, 1000)) {
	echo $data . "<br>\n";
}
fclose($fp) ;

and much to my surprise the big_dump.txt file is empty. It works fine when I run it from the NT cmd line. Any other sugestions?

Anon

are you in the right directory???

try the full path to mysqldump

Anon

Do you have error reporting turned off? I\'m still having trouble getting system() and exec() to work on Win2K using PHP 4.0.6 which is supposedly fixed. If you have error reporting off, maybe it\'s generating an error but you\'re not seeing it.

beettlle

"Error reporting"? Uhm... I get a whole bunch of other errors of other stuff(like when I forget a semicolon and such) but nothing on this one. The funny thing is that it does create the file when I run:
exec("mysqldump test > dump.txt") ;
I check the file and I actualy SEE the dump.txt but it's empty. . . I'm very confused.

Thanks for the help, =)

Anon

the file is created because it is made the standard output...

that means that 'mysqldump test' is not producing anything. check your paths and access rights on the DB. maybe you have to give a username/password....

beettlle

The path is set right and the DB provoleges are ok. If I go to the command promt and call up 'mysqldump test' I get an output no matter where I call it from. I go
'C:' <ENTER>
'mysqldump test' <ENTER>
and I get output and the mysqldump.exe is in C:\Program Files\MySQL\bin which was out of the path till I edited Autoexec.NT. Not I go 'path' and in the path I get back I can see C:\Program Files\MySQL\bin.

Thanks for the help.

Anon

i don't think PHP cares about your WINDOWS PATH variable... because that is what you are talking about.

command line, and php exec are totally different.

you have to edit php.ini to add paths. what you SHOULD do is use ABSOLUTE PATHS.

beettlle

In the php.ini I went and modified this:

;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;
include_path =

to:

;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;
include_path = "C:\Program Files\MySQL\bin\"

and still the exec("mysqldump test > dump.txt") ; doesn't do anything. Do I have to reboot my machine to get it to catch the new php.ini file?

Anon

if you are running the apache php module, you have to restart apache for changes to take affect, but changing the 'include_path' wouldn't help... you have to change your 'document_root'... which would be WRONG

please just listen and use an absolute path.