Re: How to restore data from tape

Step 0 : Backup your current db (just in case). Step 1 : Restore your database on tape to a directory DIFFERENT from your current db. Step 2 : Change DBPATH to point to the restored db. Step 3 : Retrieve information (data, schema, etc) Step 4 : Change DBPATH to point to the current db. Step 5 : Create table, load information, etc. Step 6 : Take a hard look at your application, users (examine your log, possibly) HTH. In article <5kqa03$p97@cssun.mathcs.emory.edu>, acustaf!clee@acustaf.acustaf.com (Chengteh Lee) wrote: >Do you know what is the reason that table got dropped in >informix database? We use SCO/unix and informix se. >Not only the table(only one table) disappeared in the >database, but also we found some data lost in other >tables. > >We do have tape back up. Could you please tell me how to >load the data from tname.dat and tname.idx back to database? >Should I create a temp table using tname.dat and tname.idx >(how?) and then unload data and load them to the normal table? > >Chengteh >------------------------------------------------------------ >AcuStaf Corporation Automated Staffing Systems >5001 West 80th Street Payroll, Scheduling >Minneapolis, MN 55437 Time/Attendance ... >612-831-4122 ext 248 http://www.acustaf.com >------------------------------------------------------------ ---------------------- Rudy Fernandes GIC, Kuwait OL 7.20, 4Gl 6.04 ----------------------