Can't gzip my mysqldump on the command line windows

mysql command-line mysqldump sqlcommand
Richard Skinner picture Richard Skinner · Jul 4, 2013 · Viewed 11.9k times · Source

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?

Answer

Laurence picture Laurence · Nov 2, 2013

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

Related questions

How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How to get a list of user accounts using the command line in MySQL?

I'm using the MySQL command line utility and can navigate through a database. Now I need to see a list of user accounts. How can I do this? I'm using MySQL version 5.4.1.

Read More
How to run SQL script in MySQL?

I want to execute a text file containing SQL queries, in MySQL. I tried to run source /Desktop/test.sql and received the error: mysql> . \home\sivakumar\Desktop\test.sql ERROR: Failed to open file '\home\sivakumar\Desktop\…

Read More