I'm trying to make a back up of my MySQL db and zip the file. Every time I try to run this command... <pre class="prettyprint"><code>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 </code></pre> 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?

I had this same problem myself with WAMP. All you need to do is: <ol> <li>Download gzip.exe from here: http://www.gzip.org/#exe </li> <li>Place gzip.exe in your PHP folder</li> </ol>

Can't gzip my mysqldump on the command line windows

Tags:

command-line

mysql

mysqldump

sqlcommand

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?

829

asked Jul 04 '13 13:07

Richard Skinner

1 Answers

I had this same problem myself with WAMP.

All you need to do is:

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

119

answered Oct 02 '22 18:10

Laurence

Related questions
                            
                                MySQL - Is there a way to include the bin log position in the dump file without scripting
                            
                                Converting an AM/PM time to 24 hours format using PHP or MySQL?
                            
                                MySQL GROUP_CONCAT multiple fields
                            
                                MySQL import from stdin
                            
                                Update multiple rows in a table based on result from subquery [closed]
                            
                                Sql select multiple values from another query
                            
                                How to set a mysql decimal value in java prepared statement?
                            
                                Single SQL to get multiple counts with different where clauses, is this possible? [duplicate]
                            
                                MySQLi stmt num_rows returning 0
                            
                                JDBC/MySQL: Save timestamp always using UTC
                            
                                Convert String In Python to insert into MySQL DB date column date
                            
                                Getting minute difference between two timestamps in mysql using TIMESTAMPDIFF
                            
                                Select from mysql put into variable VB.NET
                            
                                Is it possible to change the order by "DESC/ASC" in a case statment - MySql
                            
                                PHP: Mysql ("SELECT WHERE ID NOT ")
                            
                                MySQL parent children one query selection
                            
                                Use timestamp(or datetime) as part of primary key (or part of clustered index)
                            
                                Get number of rows in a result set?
                            
                                Date is inserting as 0000-00-00 00:00:00 in mysql
                            
                                Does any JDBC driver supports LOAD DATA INFILE sql command?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With