Re: dbexport/dbimport w/ new name
Posted in 1995
In article <45boit$rtt$1@mhadf.production.compuserve.com> Patrick Soehl <102121.3564@CompuServe.COM> writes:
writes...
>I'm trying to export/import a db and rename it...What I'm trying
>to accomplish is to make a copy (eventually several copies).
>1) dbexport -o /usr2/informix mumble1
>This creates a mumble1.exp
>If I use another instance, I can get
>dbimport mumble1 to work just fine.
>dbimport -i /usr2/informix mumcopy
>dbimport -i /usr2/informix/mumble1.exp mumcopy
>Both give me
>"Cannot open sql script file"
>Now, according to the "OnLine Administrator's Guide, v5.0"
>p7-9 "You can give the database a new name if you use the
>-i option". Of course, it doesn't give an example of how to
>do that.
>OnLine v5.05 uc2 AIX V3.2.5, RS6000
>TIA
>--
>No opinions, just FAX!
>Uhh... I mean FACTS!
I have done exactly this procedure using a shell script, where I do the
dbexport, then rename the nnn.exp directory, as well as the nnn.sql script in
the nnn.exp directory, subsequent to this I import the database.
I can let you have the script if you wish