Compressing mysqldump output – mysql, gzip, bzip2 and LZMA (7z)
Do a mysql dump and compress directly with gzip
mysqldump < mysqldump options> | gzip > outputfile.sql.gz
Gunzip and import using gzip
gunzip < outputfile.sql.gz | mysql < mysql options>
Do a mysql dump and compress directly with bzip2
mysqldump < mysqldump options> | bzip2 > outputfile.sql.bz2
Bunzip2 and import using bzip2
bunzip2 < outputfile.sql.bz2 | mysql < mysql options>
Do a mysql dump and compress directly with lzma
mysqldump < mysqldump options> | lzma > outputfile.sql.lzma
Unlzma and import using unlzma
unlzma < outputfile.sql.lzma | mysql < mysql options>
Related posts:
- Optimize MySQL for Low Memory Use
- Howto: How to Reset the MySQL Root Password
- Optimize MySQL Performance With MySQLTuner
- Sun acquires MySQL
- MySQL Optimization and Performance Tips
- MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
- MySQL 5.0 Release Candidate
- MySQL Performance Monitoring and Optimization Tools
- MySQL Concatenate: Adding String At The End Of Field Data
- Howto Use URL Rewriting for PHP Web Applications
Popular Related Items »
Incoming search terms
- mysqldump gzip
- mysqldump zip
- mysqldump compress
- mysqldump bzip
- mysqldump bzip2
- gunzip mysql
- mysql gzip
- mysqldump to zip
- mysqldump bz2
- mysql dump zip
- mysql dump gzip
- mysqldump with gzip
- gzip mysqldump
- mysql dump bz2
- mysqldump compression
- mysqldump gz
- mysqldump to gzip
- mysql gunzip
- mysqldump 7zip
- mysql bz2
- mysqldump zip windows
- mysqldump to zip file
- mysqldump gunzip
- mysqldump zip file
- mysqldump and gzip
- mysql bzip2
- lzma bzip2 gzip
- mysqldump with zip
- mysql bunzip
- mysqldump zipped
- mysqldump gzip windows
- compress mysqldump
- mysqldump 7z
- f
- mysqldump and zip
- 7z mysqldump
- mysql bzip
- mysql dump compress
- mysql dump bzip2
- mysqldump import gzip
- bunzip mysql
- mysql dump bzip
- mysql dump and zip
- mysqldump compressed
- mysqldump windows zip

Robert Readman said,
September 29, 2009 @ 10:37
Do a mysql dump and compress directly with 7zip (7z)
mysqldump | 7za a -si -t7z outputfile.sql.7z -mx9