> On Aug 21, 2007, at 9:38 AM, Cliff Hirsch wrote: >> How do you back up your MySQL InnoDB database? From what I can gather, I >> have two choices: >> >> 1. Stop the DB and copy the files at say 2am to reduce user disruption >> 2. Use the InnoDB hot backup program (with InnoBackup to capture the MyISAM >> files in sync) >> 3. >> A third choice, which would be my preference if I didn¹t have budget >> constraints, would be to use a replication server for backup and then stop >> that to do files copies. >> >> Am I missing anything? Any other choices? > > You can use mysqldump piped to gzip or bzip2 to create a backup. It's a bit > more intensive a process than copying files, but doesn't require stopping the > server or commercial product. > But is mysqldump viable for large tables with millions of records?
_______________________________________________ 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
