backup and recovery

Posted in 1999

Sackwitz, Antje — Sat, 7 Aug 1999 18:50:39 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, following situation: We have a full-database dump. Now I just need the information of one table. Is it possible to import into a newly created db having the same user that did the dump just that single table? Antje -- ----------------------------------------------------------- -- Antje Sackwitz Phone +49-431-7109-514 -- Vossloh System-Technik GmbH Fax +49-431-7109-502 -- Edisonstr. 3 E-Mail sackwitz@vst.vossloh.de -- 24145 Kiel -------------------------------------------------------------

↪ replying to Sackwitz, Antje

Richard Spitz — Mon, 09 Aug 1999 08:19:22 +0200 — source: Informix-list mailing list archive (1991-1998)

"Sackwitz, Antje" wrote: > We have a full-database dump. > Now I just need the information of one table. > Is it possible to import into a newly created db having the same user > that did the dump just that single table? What do you mean with "full-database dump"? - If it is a level 0 archive done with "ontape", you're out of luck. - If it is a "dbexport", you can achieve what you want by extracting the table schema out of the "<dbname>.sql" file in the "<dbname>.exp" directory and then loading the data from the "<tabname>.unl" file in the same directory. Regards, Richard -- +--------------------------+------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-6110 | | Klinikum Grosshadern | FAX : +49-89-7095-6420 <-- NEW!!! | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+