If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > dbexport

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-05-02, 11:48
mikem mikem is offline
Registered User
 
Join Date: Sep 2002
Location: Zimbabwe
Posts: 2
Exclamation dbexport

hi all,

I have this client running IDS 7.31 on mpraz. I've been tryingn to transfer their live database to their backup server running IDS 9.21 on mpraz.

I've tried using the onload and onunload utilities, which does not work due to the different versions.

So I tried dbexport from the IDS 7 machine to a 25gig tape... I am continually promted for more tapes.

Has anybody experienced something similar to this. I will do ANYTHING for the solution!!!!! (jokes)

Thanks,

Mike
Reply With Quote
  #2 (permalink)  
Old 09-06-02, 04:17
eherber eherber is offline
Registered User
 
Join Date: Aug 2002
Location: Bonn/Germany
Posts: 152
Re: dbexport

Quote:
Originally posted by mikem
hi all,

I have this client running IDS 7.31 on mpraz. I've been tryingn to transfer their live database to their backup server running IDS 9.21 on mpraz.

I've tried using the onload and onunload utilities, which does not work due to the different versions.

So I tried dbexport from the IDS 7 machine to a 25gig tape... I am continually promted for more tapes.

Has anybody experienced something similar to this. I will do ANYTHING for the solution!!!!! (jokes)

Thanks,

Mike
Have you specified the tapesize (-s tapesize) when you perform
the dbexport command ?

If both machines are the same hardware and the same O/S, I would recommend to to a backup of the 7.31 server, install the 7.31 software on the backup server, restore your backup and than
migrate to 9.21 (i.e. switching your $INFORMIXDIR and re-starting
the databaseserver).

Another solution to move the data might be the HighPerformanceLoder.

HTH.

Best regards

Eric
--
IT-Consulting Herber
www.herber-consulting.de
Reply With Quote
  #3 (permalink)  
Old 10-01-02, 13:20
erieznik erieznik is offline
Registered User
 
Join Date: Oct 2002
Location: Buenos Aires
Posts: 7
Re: dbexport

A year ago i've been through the same nigthmare (40 GB database export) There's an issue just not eberybody knows

When executing dbexport, it CAN NOT generate an export BIGGER THAN 2 GB, thats why a tape change ir required.

What I did is export to a huge filesystem, when dbexport asks for a tape change, i rename the export, compress it, an just after that, continue the export.
When importing, the same crap method is required

Hope it helps
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On