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:
Stop the DB and copy the files at say 2am to reduce user disruption
Use the InnoDB hot backup program (with InnoBackup to capture the
MyISAM files in sync)
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.
-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
