I have a question for dbimport
User ran dbexport/dbimport and got "can't open sql script file". The cause was the command syntax being reversed: they typed "dbimport rootdbs -d stores7", so dbimport looked for ./rootdbs.exp/rootdbs.sql. The correct form is "dbimport stores7 -d rootdbs" (database name first, -d names the target dbspace), and the export directory must be named stores7.exp. Also, dbimport must be run from the directory containing stores7.exp, not from inside it. Resolution given by replies; no confirmation posted back.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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
dbimport is looking for a directory called stores7.exp. move your
stores.exp to stores7.exp and it should work ok.
"sunqf"
<sunqf1980@163.co
m> To
Sent by: informix-list@iiug.org
informix-list-bou cc
nces@iiug.org
Subject
I have a question for dbimport
09/07/2006 05:30
AM
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
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
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
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
>
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 .
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