Re: 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@lsces.co.uk> 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