Re: Database Backup/Restore using Informix IDS 7.31

"Ben Thompson" <ben@nomonitorsoftspam.com> wrote in message news:11ivfn7rs38n6cc@corp.supernews.com... > None of this helps the original poster very much though. Even if they > upgraded to 9.40 or 10.00, which removes the 2Gb limit, I wouldn't > recommend using any exporting tools as a means of backup: I believe they > can only guarantee a fully consistent backup with a database on which no > updates have been done during the export. dbexport locks the database exclsuively I think, so it does enforce consistency in tat way. Most people are very sniffy about dbexport as a backup method, but for small databases where it is acceptable to suspend access I think it has some merits - the ability to do table-level "restores" for example.

Neil Truby wrote: > "Ben Thompson" <ben@nomonitorsoftspam.com> wrote in message > news:11ivfn7rs38n6cc@corp.supernews.com... > > >>None of this helps the original poster very much though. Even if they >>upgraded to 9.40 or 10.00, which removes the 2Gb limit, I wouldn't >>recommend using any exporting tools as a means of backup: I believe they >>can only guarantee a fully consistent backup with a database on which no >>updates have been done during the export. > > > > dbexport locks the database exclsuively I think, so it does enforce There's always my dbexport/dbimport clone, myexport, package. It can optionally use onpload for loads and unload with no locking and parallel unload/load it's lightning fast making it unlikely that the DB level lock will be needed. Art S. Kagel > consistency in tat way. Most people are very sniffy about dbexport as a > backup method, but for small databases where it is acceptable to suspend > access I think it has some merits - the ability to do table-level "restores" > for example. > >