On Aug 21, 2007, at 10:33 AM, Cliff Hirsch wrote:
But is mysqldump viable for large tables with millions of records?
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.
-Rob
_______________________________________________
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
