I¹m no expert, but it that¹s the case, I believe you can just use mysqlhotcopy, without stopping the database. Even if it does a lock, it should be very fast, since its a file copy, not a dump.
On 10/3/07 10:18 AM, "Anthony Wlodarski" <[EMAIL PROTECTED]> wrote: > Cliff, > > I believe we use MyISAM and after verifying it with phpMyAdmin all the types > for our tables are MyISAM. > > Regards, > > > Anthony Wlodarski > Senior Technical Recruiter > Shulman Fleming & Partners > 646-285-0500 x230 > [EMAIL PROTECTED] > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Cliff Hirsch > Sent: Wednesday, October 03, 2007 10:04 AM > To: NYPHP Talk > Subject: Re: [nyphp-talk] Scripting to get a backup of your current MySQL > database. > > On 10/3/07 9:57 AM, "Anthony Wlodarski" <[EMAIL PROTECTED]> wrote: > I was confused on the relevance of this topic but since PHP and MySQL go > together like PB&J I thought it would be relevant. > > It has gotten to the point that the application that I built for candidate > tracking is growing astronomically so now I was given the task of backing up > our data. So far our Apache/Drupal installation is backed up and SCP¹ed to a > secure server. My one big problem is backing up our MySQL database. Does the > script ³mysqlhotcopy² have the same drawback as just copy the files manually > (frm, MYD, MYI) in the sense that the server can¹t be updating anything. To > be honest I can¹t guarantee that no one in the office will not be using the > system at certain times so it might present a problem. Would it be easier to > just to script something that follows this logic: > > Pre: rename index.php, copy in temp file with downtime message > > 1.) Stop daemon. > > 2.) Copy all the table files *.frm, *.MYD, *.MYI files, tar/gzip them > > 3.) SCP archive offsite > > 4.) Delete temp folder > > 5.) Restart daemon. > > > Post: delete temp file, rename file back to index.php > > Is it unrealistic for my office to expect 100% uptime, even at 3:30 am in the > morning (those whacky recruiters). > > Anthony Wlodarski > [EMAIL PROTECTED] > > First off, what engines do you use? Mysqlhotcopy does not work for the Innodb > engine.
_______________________________________________ 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
