On 8/21/07 12:10 PM, "Rob Marscher" <[EMAIL PROTECTED]> wrote: Probably depends on how much large the data is in those records. For example, I have a database that currently has 11.5 million records and uses 2.8GB. I ran mysqldump piped into gzip. It took about 10-15 minutes and the resulting file was 71MB. Now it would probably take at least that long to restore the database from that backup though... so if you need to have a backup that can be restored with minimal downtime, having copies of the actual files would be better.
2.8GB reduced down to 71MB?! Really?! That¹s about only 7 bytes per record.
_______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
