Archive for March, 2007

On the fly compression of mysqldump output

Friday, March 30th, 2007

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.