Compressing from mysqldump on the fly?

Posted on 2006-04-20
Last Modified: 2012-05-05
I am running mysqldump from a remote database server (doing a local dump is not possible) for backup purposes. This is done daily and the bandwidth usage is a bit of a problem.

Is there a way to compress the output of mySQL dump but have that compression happen on the mySQL server as opposed to the server which is running mysqldump, because by the time the data has got to that server compressing it is no longer any use.

Question by:thepadders
    LVL 15

    Accepted Solution

    -C|--compress  Use compression in server/client protocol.

    (mysqldump option).
    LVL 15

    Expert Comment

    note - this will compress the communication between mysqldump and the server, you'll need to compress the output of mysqldump yourself ( | gz or something like that)

    Author Comment

    Oh great, thank you.

    Do you happen to know how "good" the compression is, what sort of reduction you get generally?
    LVL 15

    Expert Comment

    Hard to tell, the protocol is pretty efficient (low overhead) so it really depends on your data.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (, A SQLite Tidbit: Quick Numbers Table Generation (…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now