CODEWITHSUNDEEP
command-linemysqlsqlcommand
Richard Skinner
Richard Skinner

Reputation: 738

Can't gzip my mysqldump on the command line windows

I'm trying to make a back up of my MySQL db and zip the file.

Every time I try to run this command...

C:\wamp\bin\mysql\mysql5.5.24\bin\mysqldump.exe -u usernam -ppassword db_name | gzip > sites\www.site.com-local\backups\backup-date.sql.gz

All I get is an error saying "'gzip' is not recognized as an internal or external command, operable program or batch file'

I've used the following resources hoping they would help but have done nothing

http://www.zigpress.com/2009/04/09/enabling-gzip-on-wamp/ http://dnhome.wordpress.com/2011/10/06/apache-wampserver-enable-compression-gzip/ http://www.dewebbouwmeester.nl/enabling-gzip-on-wamp/

All say the same thing but nothing happens.

Could someone please shine some light on what i am doing wrong?

Upvotes: 5

Views: 14882

Answers (4)

Uldis Bērziņš
Uldis Bērziņš

Reputation: 1

Find or install gzip locally. After that directly in PHP folder create just gzip.bat file, specify the fully qualified path to existing gzip binary file and save. For example:C:\git\bin\gzip.exe

It's not necessary to place gzip.exe in your PHP folder.

Upvotes: 0

Abhijit Patel
Abhijit Patel

Reputation: 11

Yes, you have to put zip.exe in your wamp folder, like wamp/bin/mysql/[your mysql version]/bin.

Upvotes: 0

Laurence
Laurence

Reputation: 60048

I had this same problem myself with WAMP.

All you need to do is:

  1. Download gzip.exe from here: http://www.gzip.org/#exe
  2. Place gzip.exe in your PHP folder

Upvotes: 14

D Mac
D Mac

Reputation: 3809

That is telling you that gzip is nowhere your system can find. You can blame however you installed gzip.

Check the value of your $PATH environment (or system) variable. Then install a copy of gzip in one of those directories.

Upvotes: 0

Related Questions