How do you back up your MySQL InnoDB database? My DB is on a dedicated server in a hosted environment. 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)
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. As I understand it, it would catch up with the log files once the DB starts up again. Am I missing anything? Any other choices? Cliff Hirsch
_______________________________________________ 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
