I have a question for dbimport
This is a discussion on I have a question for dbimport within the Informix forums, part of the Database Server Software category; --> I use dbexport rootdbs -d stores7 common to export this db . so this is create stores.exp directory include ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 12:59 PM
| |||
| |||
 Re: I have a question for dbimport 2 questions 1/ what is in the file stores7.sql 2/ what directory are you in when you run the dbimport command sunqf wrote: > I use dbexport rootdbs -d stores7 common to export this db . so this > is create stores.exp directory include "*.nul" and " stores7.sql " > files . > so I use dbimport rootdbs -d stores7 but informix tall me that is error > . > this dbimport.out file tall me "cann't open sql script file " . > I use this common at same directory and same user . and I can open > stores7.sql this file . > can you help me ? > that is way      |
|
04-20-2008, 12:59 PM
| |||
| |||
| Re: I have a question for dbimport sunqf wrote: > I use dbexport rootdbs -d stores7 common to export this db . so this > is create stores.exp directory include "*.nul" and " stores7.sql " > files . > so I use dbimport rootdbs -d stores7 but informix tall me that is error You have that backwards, it should be: dbimport stores7 -d rootdbs > . > this dbimport.out file tall me "cann't open sql script file " . > I use this common at same directory and same user . and I can open > stores7.sql this file . It would have been looking for ./rootdbs.exp/rootdbs.sql > can you help me ? > that is way > |
|
04-20-2008, 12:59 PM
| ||||
| ||||
| Re: I have a question for dbimport sunqf wrote: > scottishpoet 写道： > > > 2 questions > > > > 1/ what is in the file stores7.sql > > > > 2/ what directory are you in when you run the dbimport command > > > yes that stores7.sql file in stores7.exp directory . As richard said : dbimport rootdbs -d stores7 but informix tall me that is error You have that backwards, it should be: dbimport stores7 -d rootdbs and when you run the dbimport you need to be in the directory that contains the stores7.exp, not the directory that conatins the stores7.sql |
Linear Mode
