To run SQL dumps through gzip compression on the fly<\/p>\n
1) Create a named pipe to destination for the sql spool using this command:<\/p>\n
\nmknod output.pipe p<\/p><\/blockquote>\n
2) run a process in the background to compress any data sent to the named pipe<\/p>\n
\nnohup gzip -c < output.pipe > output.gz &<\/p><\/blockquote>\n
3) Set up your SQL to spool to the named pipe<\/p>\n
\nset feedback off
\nset heading off
\nset pagesize 0
\nset linesize 2000
\nset space 0
\nset newpage 0
\nset verify off
\nset termout off
\nset echo off
\nset wrap off
\nset flush off
\nset trimspool on
\nspool \u2018output.pipe\u2019;
\nselect XXXX from XXXX
\nspool off;
\nexit;<\/p><\/blockquote>\n4) Run the SQL and the output will be zipped up as it is created and put in the output.gz file\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"
To run SQL dumps through gzip compression on the fly 1) Create a named pipe to destination for the sql spool using this command: mknod output.pipe p 2) run a process in the background to compress any data sent to … Continue reading