Re: dbexport/import
stimmel@fsl.noaa.gov (Carol Stimmel) wrote:
>Hi,
>I am attempting to dbexport a database from one
>installation of Informix Online 5.0 to another
>installation (same release). I create the sql
>file and all the associated data files (*.unl)
>using dbexport without a problem. What I would
>like to do, though, is import the database to
>it's own dbspace instead of the rootdbspace on
>the new machine.
>the first line of my sql file states:
>{ DATABASE wfoden delimiter | }
>I was hoping I could just specify the new db
>space here, but no luck. The import program
>reports that the sql file is corrupt if I
>say:
>{ DATABASE wfoden in wfodendbs delimiter | }
>
>and ignores me if I say:
>{ DATABASE wfoden delimiter | in wfodendbs }
>and puts it in the rootdbs, anyway.
>As usual, your assistance is much appreciated
>in this manner. Even a pointer to the correct
>manual would help, as I don't seem to be able
>to track such a thing down.
The first line that specifies {Database ..........} is strictly a
comment in a dbexported generated file.
If you want to change the dbspace, simply use the -d dbspacename on
the dbimport command.
dbimport dbname -d dbspacename ......
--
Melvin Mariney, Informix DBA
e-mail: melvin.mariney2@bridge.bst.bls.com