Re: dbexport/import
Carol,
Since you've dbexported the database, you can
use a flag on dbimport to put the database in
a different dbspace. The syntax is
dbimport wfoden -d dbspacename
If you need any further info, see 7-11 of the
Online Admin.'s Guide.
If you didn't want to use dbimport, you could
always get into dbaccess and create a database
using the Query Language Menu option. Then you
would "create database wfoden in dbspacename"
You would still have to run your .sql file from
your dbexport and load all of your data your-
self. Have fun,
Tracy W. Nedd
National Weather Service - DBA
vball@skipper.ssmc.noaa.gov
p.s. I work with the Hydrobase group, if you wish
to reach me by phone.
}
} 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.
}
} --
} Carol
} *********************************************************
} Carol L. Stimmel NOAA/ERL/FSL
} Systems Analyst stimmel@fsl.noaa.gov
} *********************************************************
}