Subject | Re[2]: [firebird-support] insert data two databases different |
---|---|
Author | Joel Moo |
Post date | 2019-05-07T14:25:41Z |
Hi Mark, the OS is linux (Debian 8), but i stopped the service of
firebird before renaming the file .fdb.
Cualquier duda o comentario adicional, quedo a sus órdenes.
Excelente día.
Joel de Jesús Moo Arguelles
Administrador de Base de Datos
VERTICAL KNITS S.A DE C.V
Tel. (991) 9 13 00 57 ext. 159 Fax: (991) 9 13 02 52
joel.moo@...
www.verticalknits.com
------ Mensaje original ------
De: "Mark Rotteveel mark@... [firebird-support]"
<firebird-support@yahoogroups.com>
Para: firebird-support@yahoogroups.com
Enviado: 07/05/2019 09:19:57 a. m.
Asunto: Re: [firebird-support] insert data two databases different
firebird before renaming the file .fdb.
Cualquier duda o comentario adicional, quedo a sus órdenes.
Excelente día.
Joel de Jesús Moo Arguelles
Administrador de Base de Datos
VERTICAL KNITS S.A DE C.V
Tel. (991) 9 13 00 57 ext. 159 Fax: (991) 9 13 02 52
joel.moo@...
www.verticalknits.com
------ Mensaje original ------
De: "Mark Rotteveel mark@... [firebird-support]"
<firebird-support@yahoogroups.com>
Para: firebird-support@yahoogroups.com
Enviado: 07/05/2019 09:19:57 a. m.
Asunto: Re: [firebird-support] insert data two databases different
>[Non-text portions of this message have been removed]
>On 6-5-2019 23:12, 'Joel Moo' joel.moo@...
>[firebird-support] wrote:
> > Hi guys, i have a situation, I work with a database name
>database1.fdb,
> > and so, i do maintanance over this databases weekly.
> >
> > I backup this database before maintenance, but the maintenance
>failed,
> > so the .fdb file in which the maintenance failed will rename it to
> > database_2, and then restore the database1.fdb file.
> > 2 days later for some reason the information was inserted in database
> > database_2 and not in database1.fdb. It is worth mentioning that
>these
> > files and the database.config were not modified again
> >
> > Any advice or experience with a similar situation?
>
>Was it a Linux system, did you rename the database file while any
>Firebird process was still connected to that database? If so, those
>processes will continue to use the old database.
>
>Mark
>--
>Mark Rotteveel
>
>