Re: Export to Tape - How?

From: Madhu Aiyappen <madhu>
Date: 1996/01/17
Message-ID: <4dj71l$2lk_at_radon>#1/1


The one reason why you want to do this is to save disk space. Also If you are on a Unix system, you have a 2G limit on file size. If you are exporting a table over 2G, you can export to a pipe and compress the output on the fly. I have seen 60-80% compression on file.

step 1: /etc/mknod <pipename> p

step 2: use this pipename as export file.

step 3: compress < pipename > newfilename.

# now your exported data is in newfile name.

When you want to import do the reverse.

  1. mknod pipename p
  2. uncompress < newfilename > pipename
  3. use pipename for import file.
Received on Wed Jan 17 1996 - 00:00:00 CET

Original text of this message