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:

  1. Optimize MySQL for Low Memory Use
  2. Howto: How to Reset the MySQL Root Password
  3. Optimize MySQL Performance With MySQLTuner
  4. Sun acquires MySQL
  5. MySQL Optimization and Performance Tips
  6. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
  7. MySQL 5.0 Release Candidate
  8. MySQL Performance Monitoring and Optimization Tools
  9. MySQL Concatenate: Adding String At The End Of Field Data
  10. Howto Use URL Rewriting for PHP Web Applications

Popular Related Items »

1 Comment »

  1. 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

RSS feed for comments on this post · TrackBack URI

Leave a Comment