Import and Export With Compressed Files

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 13 Sep 2002 10:27:34 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702A529F2@lnewton.leeds.lfs.co.uk>

Or, replace 'compress' with gzip -9 for a slightly slower export/import, but much better compression - the exp file is very much smaller than that produced by compress.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: srivenu_at_hotmail.com (srivenu) [mailto:srivenu_at_hotmail.com] Posted At: Friday, September 13, 2002 7:22 AM Posted To: server
Conversation: Import and Export With Compressed Files Subject: Re: Import and Export With Compressed Files

Export

1. mknod /tmp/export p
2. compress < /tmp/export > export.Z &
3. exp file=/tmp/export userid=...............

Import

1. mknod /tmp/import p
2. uncompress < export.Z > /tmp/import &
3. imp file=/tmp/import userid=...........

regards
Srivenu Received on Fri Sep 13 2002 - 04:27:34 CDT