Subject | Re: Restore when Apache is connected |
---|---|
Author | xdenser |
Post date | 2010-07-06T13:24Z |
Apache/PHP may hold persistent connection to DB so the DB file is open and you can not overwrite it. Try to restart apache just before copying DB file, so it will close any open connections. You just have to ensure that nobody will access database via web server immidiatelly after restart. Use some config file to check if the db can be accessed from php.
--- In firebird-php@yahoogroups.com, "Balagopal" <bkarat@...> wrote:
>
> Thanks Lester Caine.
>
> Yes, in the C/S part we ensure that all the users are disconnected before doing a restore. Now the complication has come because of Apache. 'Restore' is used only when something happens to the DB and is very rarely used by our customers.
>
> Best regards,
> Bala
>
>
> --- In firebird-php@yahoogroups.com, Lester Caine <lester@> wrote:
> >
> > Balagopal wrote:
> > > We have a C/S application that uses Firebird (2.1). Recently we made a web extension to this application using PHP. We have a back-up/restore utility as part of the C/S software. The restore function (this copies the backed-up database file to the actual location) fails if Apache is connected.
> > >
> > > Any way to do restore when Apache is connected?
> >
> > Basically ... NO ... the database has to be shut down to single user mode for a
> > restore, but why would you want to run the restore onto the live database? It
> > would be better to restore to a new database and then simply switch them,
> > although personally I rarely restore the copy that I am working with. Just
> > restore a nightly backup to a new file to ensure that there are no problems with
> > the 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//
> > Firebird - http://www.firebirdsql.org/index.php
> >
>