How to Compressing MySQLdump output file

The result of mysqldump is a flat text file containing the sql commands used to restore the mysql databases/tables that were dumped. Normally the result of mysqldump is compressed (in regular backups) because the size of the resulted file is normally big and good compression rates are achieved on such text files.
To do this manually using gzip we just run:

gzip -v outputfile.sql

This quick tip shows how you can run the same thing on the fly with only one command directly compressing the resulted file. This might be useful in situations where space is a problem and the full dump can’t be saved on the available storage directly because of its size. Also this might be useful to not run it in 2 commands and have one compact command (maybe used also in some backup scripts, etc.)

mysqldump < mysqldump options> | gzip > outputfile.sql.gz

When restoring from a compressed file we can manually uncompress it first:

gunzip -v outputfile.sql.gz

or again we can run in the same command line mysqldump and gunzip:

gunzip < outputfile.sql.gz | mysql < mysql options>

Download: mengkompresi-output-mysqldump.ppt

mysqldump compress, mysqldump, menyimpan array di mysql, script my sql rename database, cara rename database, rename database via terminal, oracle query mengubah nama kolom, mysqldump gzip windows, mysqldump command, mysql dump with compresion, menampilkkan data array dari dalam database, memasukan array ke dalam database mysql, Compressing mysqldump output in windows, compress dan decompress dengan vb6, cara mysqldump di fedora 16

Tulisan Terkait

• Belajar PHP: Membuat Cron Backup database + kirim hasil ke email Gmail
• New Moodle.org Plugin Database is now live
• psycopg2ct 0.1
• LimeSurvey 1.91 Build 10859
• Pyrseas 0.3.1
• Backup MySQL tabel per tabel dengan rotasi otomasi
• Membuat Sistem Informasi Akademik (Part 2: Desain dan Hirarki Folder)
• Membuat Sistem Informasi Akademik (Part 1: Design Aplikasi)
• How to use MySQL Query Browser on Remote Database on Mandriva
• Twitter will Changes Tweet Storage Strategy (via TechCrunch)