Re: dbexport/dbimport question ??

hongy@domino.jpl.nasa.gov (Hong Yuan) wrote: >Hi, >I have a database named 'db' created with log (se engine on a >HP-9000/725). I first did: >dbexport db >(I have Version 6.00.UE1.) >Then I changed db.exp to db2.exp, and changed db.sql to db2.sql: >mv db.exp db2.exp >cd db2.exp >mv db.sql db2.sql >When I tried to create the new database by doing: >dbimport db2 >db2 got created fine. But when I tried: >dbimport db2 -l ./db2.log >got this message: "Cannot open sql script file" >WHY ?? >Whay I really want is to copy db to db2. Is there a better way? >Any advise will be greatly appreciated. >Thanks! >Hong Yuan. I did the exact thing you are trying a couple of weeks ago. You must be sure your directory structure for your new database is exactly like the db.exp directory started. You also need to make sure the db2.sql file is under the db2.exp directory. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com