On the fly compression of mysqldump output « Squarebits Blog

On the fly compression of mysqldump output

Found this tip here — you can compress your mysqldump output by executing…

mysqldump my_database_name | gzip > my_database_name.sql.gz

You can even process these compressed files directly by executing…

gunzip < my_database_name.sql.gz | mysql -D my_database_name

Very useful to process backups/restores with limited disk space on a server.

This entry was posted on Friday, March 30th, 2007 at 4:26 pm and is filed under MySQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “On the fly compression of mysqldump output”

KYLE says:

July 21, 2010 at 11:16 pm

MedicamentSpot.com. Canadian Health&Care.Special Internet Prices.Best quality drugs.No prescription online pharmacy. No prescription pills. Order drugs online…

Buy:Arimidex.Valtrex.Mega Hoodia.Zyban.Lumigan.100% Pure Okinawan Coral Calcium.Nexium.Synthroid.Prevacid.Zovirax.Accutane.Prednisolone.Petcam (Metacam) Oral Suspension.Human Growth Hormone.Retin-A.Actos….

Leave a Reply