Re: Import and Export With Compressed Files

Norman Dunbar wrote:
>
> 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

Funnily enough I prefer the opposite (gzip -1) to sacrifice the space for faster export/import...

Then again, pretty much any version of gzip is still at the "can't go above 2G" range, whereas many versions of compress are still fine. Then you're into "split" in there as well...ugh!

Cheers
Connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."