Web lists-archives.com

Re: [PHP] One Button DB backup [Solved]




On 24/11/16 18:33, Tedd Sperling wrote:
>> > On Nov 24, 2016, at 11:51 AM, Lester Caine <lester@xxxxxxxxxxx> wrote:
>> > 
>> > On 24/11/16 16:30, Tedd Sperling wrote:
>>> >> The “opt" does a lot of things including locking the db down.
>> > 
>> > I might ask ... how long is the database out of action for ;)
> 
> I assume it lock things down until the database is downloaded — in my case, just a few seconds (<10).
> 
> My assumption seems to be correct because after I download the database, I was able to access it.
> 
> Please correct me if I am wrong, because I did it yesterday and everything is still working today.

My somewhat old information is that for a MySQL based system one should
restrict access to the application while the backup is made. Faster
machines have reduced the time taken, but if the volume of data was to
increase dramatically so would the time taken to back up? Some of my own
systems can take several minutes to create the backup file which is
still in the gigabytes after backing up but I don't have to stop web
access as the backup will be a snapshot of the data at the time the
process started. I have one with the CDDB data stored locally which
needs 30 minutes for a backup ;)

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php