CODEWITHSUNDEEP
phpgzipmysql
mojobullfrog
mojobullfrog

Reputation: 189

Using gzip compression with mysqldump

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");

Upvotes: 4

Views: 5351

Answers (1)

D Mac
D Mac

Reputation: 3809

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

Upvotes: 7

Related Questions