007 2:43 PM
To: NYPHP Talk
Subject: Re: [nyphp-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 bac
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:
"
Senior Technical Recruiter
Shulman Fleming & Partners
646-285-0500 x230
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Rolan Yang
Sent: Wednesday, October 03, 2007 11:44 AM
To: NYPHP Talk
Subject: Re: [nyphp-talk] Scripting to get a ba
If you want to do a database backup with no downtime, replicate to a
second mysql machine. You can stop the slave and perform a dump. Then
after the dump is complete, it will sync back up upon restart. If you're
really tight on hardware resources, you might even be able to start a
second instan
ober 03, 2007 10:25 AM
To: NYPHP Talk
Subject: Re: [nyphp-talk] Scripting to get a backup of your current MySQL
database.
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, si
gt; 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 Wloda
CTED] 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
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
