[mythtv-users] Backing up mysql database.

Jay R. Ashworth jra at baylink.com
Wed Sep 5 18:29:05 UTC 2007

On Wed, Sep 05, 2007 at 10:07:59AM -0700, David Brodbeck wrote:
> If you do use mysqldump, a tip -- the resulting text files compress  
> *very* tightly with gzip.  I've seen compression ratios approaching  
> 10:1 on dump files, because so much of the text is duplicated.

There's an amazing amount of air in databases; moreso in the dumps.

They squeeze *very* nicely.  I've personally seen quite a bit more than
10:1, on occasion.

-- jra
Jay R. Ashworth                   Baylink                      jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates     http://baylink.pitas.com                     '87 e24
St Petersburg FL USA      http://photo.imageinc.us             +1 727 647 1274

More information about the mythtv-users mailing list