RE: [Q] dbexport, dbimport usage.

> Hi, all > > I'd installed informix on linux box. I curious about dbimport > and dbexport. > How can I use dbexport and dbimport ? I just did dbexport store database. > But when I tried to dbimport from exported directory, I got error message. > 'can't open sql script file'. what's mean error message ? how can i use > dbimport ? Check for your complete path , from where you are running dbimport. It has to be carried out at a level just before the .exp folder which it has created when you took export. also the name of the .exp folder must match to the name of the .sql file which lies within the .exp file. Also check for all the prameters required for dbimport/dbexport by just typing dbimport at the command prompt, it will show you the usage of the command. > Would you let know why use dbimport and dbexport ? is it for data > backup or > schema backup ? I can't find document. It is definitely for both. when it is not possible to move large data from one database server to another, it is always advisable to take an export and then import it back where you want it. The .exp folder contains a .sql file which holds the schema for the database you just exported and .unl files which contain pipe delimited data for the tables lying in the database. You can open these files in any standard text editor, but don't modify them unless you are sure else your import will not be proper. HTH, _____________________________________________ Anil Kulkarni. ' L&T Information Technology Ltd., Pune - India. Tel : 91 20 5530813 to 5530818. ' Web: http://www.ltitl.com _______________________________________________