NYCPHP Meetup

[Rob Marscher]

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.)"