Id recommend Chapter 17 of Pro MySQL (Jay Pipe's book) for great
backup/restoration tips on the subject. I don't think you are
missing anything but he points out you could just copy raw files like
you suggest (although when you say "replication" I think you may need
binary logging enabled which may/may not be running in your
environment). The administrator tool is also a pretty good option.
- Jon
On Aug 21, 2007, at 9:38 AM, Cliff Hirsch wrote:
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:
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. 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
_______________________________________________
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
