Zip does not work for big files

compressiongziptar

What is the best way to compress a file if it is more than 4 GB in size?

I am using the following for last several months.

mysqldump --all-databases | zip > mybackup.zip

Today I am got an error:

zip error: Entry too big to split, read, or write (file exceeds Zip's 4GB uncompressed size limit)

I am considering using bzip2. Is my choice correct?

Best Answer

Why not use the industry standard for this kind of stuff: "gzip"?

mysqldump --all-databases | gzip > mybackup.gz

Size Comparison:

720K    mybackup.gz     (compressed)
2.6M    mybackup.sql    (same data, but uncompressed for comparison)