NYCPHP Meetup

[Anthony Wlodarski]

I assume a ten minute window as I have not done it before.  I am going to
have Cron call that script but just to make sure at the start of the script
I am going to make sure people don't have access to the CMS so the database
doesn't try to update itself.  I found that link useful, actually found it
before I posted on the user group.

Anthony Wlodarski
Senior Technical Recruiter
Shulman Fleming & Partners
646-285-0500 x230
aw at sap8.com


-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of Rob Marscher
Sent: Wednesday, October 03, 2007 2:43 PM
To: NYPHP Talk
Subject: Re: [nycphp-talk] Scripting to get a backup of your current MySQL
database.

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