[mythtv-users] Backing up mysql database.

[Jay R. Ashworth]

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.

Cheers,
-- 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