Re: Exporting a large database

Hi,

Export to tape is not limited.

Another example is export to tape and compress: This is an AIX example (/dev/rmt0)

export:

mknod /tmp/fifo p # create a pipe compress < /tmp/fifo|dd of=/dev/rmt0 ibs=512b obs=64k conv=sync& # large obs for speed exp scott/tiger file=/tmp/fifo tables=emp

import:

imp scott/tiger file=/tmp/fifo tables=emp& uncompress < /dev/rmt0 > /tmp/fifo

gzip works similar, only use gzip -d to expand

regards,

Toni

PS:

To export to the tape of another host:

tar -cvf- your-file|rsh onother_host dd of=/dev/rmt0 obs=64k ibs=512b

You may want to merge this precodure ;-)

Sorry about you NT-peoples. SCNR Received on Tue Jan 25 2000 - 08:28:51 CST