Hi Paul

Access to temp is OK -
Taking the database I restored with the -i switch I can back that up
remotely using IBExpert - which by default puts the backup in /tmp

I can restore it from there but still cannot activate the indexes on
the restored version

As noted in the response from Helen it would be nice if it actually
listed the I/O file it wants, instead of giving a blank name.

There has to be some difference between the checking in the WIN and
LINUX versions

John

--- In firebird-support@yahoogroups.com, "Paul Beach" <pabeach@...> wrote:
>
> Hi John,
>
> ? - Problems with access to /tmp perhaps?
>
> Regards
> Paul
>
> > gbak: activating and creating deferred index MRPSELECT_IDX1
> > gbak: activating and creating deferred index MRPSELECT_IDX4
> > gbak: activating and creating deferred index MRP_IDX1
> > gbak:cannot commit index MRP_IDX1
> > gbak: ERROR:I/O error for file ""
> > gbak: ERROR: Error while trying to open file
> > gbak: ERROR: No such file or directory
> > gbak: activating and creating deferred index MRP_IDX2
> > gbak:cannot commit index MRP_IDX2
> > gbak: ERROR:I/O error for file ""
> > gbak: ERROR: Error while trying to open file
> > gbak: ERROR: No such file or directory
> > gbak: activating and creating deferred index MRP_IDX3
> > gbak:cannot commit index MRP_IDX3
> > gbak: ERROR:I/O error for file ""
> > gbak: ERROR: Error while trying to open file
> > gbak: ERROR: No such file or directory
> > gbak: activating and creating deferred index PK_MRP
> > gbak:cannot commit index PK_MRP
> > gbak: ERROR:I/O error for file ""
> > gbak: ERROR: Error while trying to open file
> > gbak: ERROR: No such file or directory
> > gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
> > gbak: ERROR: Cannot deactivate index used by a PRIMARY/UNIQUE
> > constraint
> > gbak:Exiting before completion due to errors
> >
> >
> >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>