[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.
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