Re: dbimport
In article <54640r$js9@cssun.mathcs.emory.edu>, ukantjx@lexis-nexis.com
says...
#
#Hi,
#
#I have taken a dbexport using
#dbexport DBNAME
#It created a DBNAME.exp directory on the disk and inside it some .unl
#file
#and one sql script.
#
#Can anyone please tell how I can import using dbimport . I wrote
#dbimport DBNAME -i DBNAME.exp -f pcdip.sql . But it gives a error
#message
#"Can not write data to disk and tape at the same time
#I need help urgently as my Database is live.
#
Dear Rowell Franc,
let me put my answer in the next way:
1. For example, you have created directory /u/usr/unload.
2. Than you have taken a dbexport using dbexport DBNAME.
3. To import your database DBNAME go to /u/usr/unload and type the next:
dbimport DBNAME -d{dbspace_name} -l {create database with log}.
Check your environment variables before database import.
For more information see Informix Guide to SQL: Reference.
Igor