Re: Restoring a single table

In article <33CD0AA6.6DDC@infoave.net> mbrickley@infoave.net writes: >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. SE's just a collection of unix files. Assuming the database is quiescent, just write a tar or cpio script that copies all the files to your test area, and hack away. Use a cron job every night, if necessary. Peter Wiley