dbimport question: IDS 5.x

I am attempting to fix a problem I am having with indexes and as part of this fix, the Informix Tech support person suggested that I do a dbexport of the database followed by a dbimport of the database. As I am fairly new to the product, I have a question about this. Once I have exported the database, is there anything I need to do before I import the database? Will the import write over what is currently there? Does dbexport remove the database, or just write out how the database is configured as well as what is in it? If it just writes out what is there, then do I need to drop the database before I do the import? Answers either here or at my email address will be appreciated. *!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!* Don Conley * email: conley@col.hp.com IT Solutions Specialist * Hewlett-Packard Co. * Colorado Springs, Colorado USA * (719) 590-2167 * *!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*

Donald You will need to physically drop the database before doing a dbimport. Of course, I would suggest backing up the database before dropping. BTW Did you try dropping and recreating the index? the table? before considering dropping the database? HTH Sujit In article <7788f1$c0$1@nonews.col.hp.com>, conley@col.hp.com (Donald Conley) wrote: > I am attempting to fix a problem I am having with indexes and as part of this fix, the Informix Tech support person suggested that I do a dbexport of the database followed by a dbimport of the database. As I am fairly new to the product, I have a question about this. Once I have exported the database, is there anything I need to do before I import the database? Will the import write over what is currently there? Does dbexport remove the database, or just write out how the database is configured as well > as what is in it? If it just writes out what is there, then do I need to drop the database before I do the import? > > Answers either here or at my email address will be appreciated. > > *!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!* > Don Conley * email: conley@col.hp.com > IT Solutions Specialist * > Hewlett-Packard Co. * > Colorado Springs, Colorado USA * > (719) 590-2167 * > *!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!* > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own