Re: Restoring a single table

Posted in 1997

Matt Brickley — Wed, 16 Jul 1997 13:53:42 -0400 — source: Informix-list mailing list archive (1991-1998)

bowman@uthscsa.edu wrote: > > I'm running Informix SE 7.01. I have a situation where I need to restore > a table into a working area, but not disturb the actual production table. > I've gotten the .dat and .idx files restored into a temp directory. Is > there any way to create a database and table in this working area and > have the data restored from the .dat file? I've restored data this way > before, but always into the original database. > I am on SE 5.0, but can't you use dbexort and dbimport? I do it all the time for databases and individual tables. Its great for testing, because you can reload data after your test program has hosed it. HTH, Matt Brickley