On Oct 3, 2007, at 12:16 PM, Anthony Wlodarski wrote:
I think for sake of ease of doing this project we will just have a ten
minute drop on the server at midnight every night to backup the
database.
I doubt it will take 10 minutes. From http://dev.mysql.com/doc/
refman/5.0/en/backup.html:
"You can also create a binary backup simply by copying all table
files (*.frm, *.MYD, and *.MYI files), as long as the server isn't
updating anything. The mysqlhotcopy script uses this method. (But
note that these methods do not work if your database contains InnoDB
tables. InnoDB does not store table contents in database directories,
and mysqlhotcopy works only for MyISAM tables.)"
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
