RE: dbexport/dbimport w/ new db name
>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. I've even made a copy of the the mumble1.sql file and
>modified it to create database mumcopy and I still get the same
>message.
>I sure would appreciate some help. TIA.. pnsoehl
>OnLine 5.05.uc2, AIX 3.2.5
You can always do this before loading:
1) Rename the dbs.exp directory to dbname.exp.
2) Rename the sql file in that directory to dbname.exp.
3) Edit the sql file in the sql directory. Change the first comment in
file to contain the name of the new database.
Mark Denham
BBC
London, UK
Mark.Denham@bbc.co.uk