--- In firebird-support@yahoogroups.com, "Martin Dew" <martin.dew@...>
wrote:

>
> </snip>
>
>
>
> >If that works, then have your script 1) rename
> >the old database and zip it up and then 2) rename the new database to
> >the real database name.
>
> >./heLen
>
>
>
> From experience I have not found that a good practice if you are
> splitting your db into multiple files, as the file allocations in the
> gdb header do not get changed when you rename the file, am I missing
> something here ??

I think Helen is more stating the case to not use -R. If the restore
fails for whatever reason, the database that was there beforehand is gone.

You could of course go the other direction and rename the database
that is already in the folder to something else, and restore the
database to the correct filename. This would make sure the references
are in tact. Of course you would need to make sure by some other
mechanism that no-one connects during the restore (like removing the
alias). Unless you are using some ancient file system, you don't need
to split the files by the way.


Adam