Using gzip compression with mysqldump

Question

Can anyone provide an example of how I can include a path to my zip compression software within the following php code? The code works when dumping into a simple sql file, however, gzip compression obviously relies on including the correct path.

$dumpfile = $dbname . ".sql.gz"; 

passthru("c:\\xampp\\mysql\\bin\\mysqldump.exe --opt --host=$dbhost --user=$dbuser --password=$dbpwd $dbname | gzip -v -9 > $dumpfile");  

Answer 1

You are missing the -c option to gzip that tells it to output to standard output. Otherwise it expects to operate on files.

use ... | gzip -9 -c > $dumpfile