Pipe Database Export to Zip

From NazimWIKI
Jump to navigation Jump to search

Using fifo (first in first out) you can redirect your database exports through a pipe straight to zip.

Make fifo pipe:

mkdir fifo db.fifo


Write the file output to gzip and send to background:

cat db.fifo | gzip > db.dmp.gz &


Run the export to the fifo pipe:

exp username/password file=db.fifo log=db.log etc