Re: unload / reload blues

In article B7D@metronet.com, gwr@metronet.com (George Rapp) writes: >I can't seem to find the magical incantation to back out my data from >one Informix server and load it into another server. Any help would be >appreciated. > >I am running Informix OnLine 5.02.UC1 on two machines: a runtime version >on my production machine "server01" (a Sun 4/280 running SunOS 4.1.3), >and a development version running on my test machine "server0" (a >Sun 4/110 - please try not to laugh - also running 4.1.3). The >plan was to transfer production data each evening to the test server, so >we can test with almost-live data. There is about 400 MB of data to be >transferred. > [ Deleted Text ] >Questions: > 1) How can I get a "duplicate key" error if I just wiped my dbspace? > Is there any way to kill off whatever other key is duplicated? > 2) Did I miss something obvious in the tbunload/tbload sequence of > commands? Does remote access even work? (The tape appears to > spin, but not for very long.) > 3) Is there a better way to do this? > >Thanks in advance for any assistance. > I do not know what your "duplicate key" problems is other than to say you may well have a duplicate key in one of your tables. But there is a simpler way to do the transfer between both machines using tbload, tbunload if you have a common mount point on your test machine you. On the production machine mknod pipename p chmod 777 pipename tbunload -t pipename fromdbname On the test machine tbload -t pipename newdbname I saw this method on the net many months ago and I believe that I tried it then and it worked, though not across a mount, but that "should" not make a differenct :-) I hope this helps ------------------------------------------------------------------------------ | Phillip Drury. | | | SBC Australia Limited. | Email : pld@syd.au.swissbank.com | | Sydney Australia. | Next Email : drury@il.us.swissbank.com | ------------------------------------------------------------------------------