SQL export mod on Win2k can't find executable

[Wils]

Using BACKUP_MYSQL_ADMIN_PLUGIN-1.2.0.10a on a Win2k box, I get

Warning Result code: 1
Warning 0 => 'c:/mysql/bin/mysqldump.exe" "--host' is not recognized as an internal or external command,
Warning 1 => operable program or batch file.

Have edited the language file (backup_mysql.php) to:

define('LOCAL_EXE_MYSQL', 'c:/mysql/bin/mysql.exe');
define('LOCAL_EXE_MYSQLDUMP', 'c:/mysql/bin/mysqldump.exe');

However, running it in DOS works, using

c:\mysql\bin\mysqldump.exe my_database -u root -p

Have tried changing / to \ but this gives:

0 => 'c:\mysql\bin\/mysqldump.exe" "--host' is not recognized as an internal or external command,

Any clues? All input appreciated.

[Wils]

... polite bump, perhaps I posted in the wrong place.

[DrByte]

It seems it doesn't like the way quotes are used around the command parameters.

On line 134 of /admin/backup_mysql.php you should find:

        // remove " marks in parameters for friendlier IIS support
//REQUIRES TESTING:        if (strstr($toolfilename,'.exe')) $dump_params = str_replace('"','',$dump_params); 

You could try removing these characters: //REQUIRES TESTING:
so that you're left with:

        // remove " marks in parameters for friendlier IIS support
       if (strstr($toolfilename,'.exe')) $dump_params = str_replace('"','',$dump_params); 

Then test the process again.

[Wils]

Thanks for the quick answer.

The file /admin/backup_mysql.php contains something else on line 134, and no reference to IIs (also checked the file from the current download area just now, v1.2.10).

I'll have a look at the code to see if I can work it out anyway, but if you have an updated version it would be great to have a go at that.

[neteasy]

Wils, did you solve the problem?

[neteasy]

ok.. just found a post by dwno...

admin/backup_mysql.php
replace

$resultcodes = @exec($toolfilename . $dump_params , $output, $dump_results );

with

$resultcodes = @exec('"' . $toolfilename . $dump_params . '"', $output, $dump_results );

and

$resultcodes=exec($toolfilename . $load_params , $output, $load_results );

with

$resultcodes=exec('"' . $toolfilename . $load_params . '"', $output, $load_results );

Not tested on *nix yet, just my dev computer running winblows xp.

[Wils]

Great !! It woks on my Win2K box. Super thanks.

/Wils