Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

dbexport/dbimport w/ new name

366 views
Skip to first unread message

Patrick Soehl

unread,
Oct 9, 1995, 3:00:00 AM10/9/95
to

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!

Patrick Soehl

unread,
Oct 9, 1995, 3:00:00 AM10/9/95
to
Sorry for the double posting. My newsreader STILL couldn't see my
earlier request until a few minutes ago.


Claude Chesselet

unread,
Oct 12, 1995, 3:00:00 AM10/12/95
to
In article <45boit$rtt$1...@mhadf.production.compuserve.com> Patrick Soehl <10212...@CompuServe.COM> writes:
writes...

>This creates a mumble1.exp

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


Billy Wheeler

unread,
Oct 17, 1995, 3:00:00 AM10/17/95
to
Patrick Soehl <10212...@CompuServe.COM> wrote:
>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"

Patrick,

Those who know me will know that I'm not renowned for the subtlety of
my solutions... :)

I usually approach this with a much more blunt approach: I mv the .exp
directory to the new name and then mv the .sql script in the .exp
directory to the new name. Then: no problem...

HTH!
--

Cheers,

Billy

-----------------------------------------------------------------------------
INCLUDE "Disclaimer.4gh" -- my opinions are
INCLUDE "FlamesToDevNull.4gh" -- flamers, eat my shorts!
INCLUDE "CaveatEmptor.4gh" -- take my advice at your own risk
INCLUDE "ThirtySomething.4gh" -- header file for this class

-- Written by : Billy Wheeler, Date: today
-- Copyright (c) 1995, The West Solutions Group


0 new messages