Description:
Dear mysql developers---
Would it be difficult to allow for real pipes as input into mysql?
LOAD DATA INPIPE 'zcat compressed.gz |' INTO TABLE mytable;
this would feed the output of 'zcat compressed.gz' instead of a file.
The named pipe route is really rather painful and complex---especially if I want to write an SQL file that creates a few hundred tables. I would first have to create a shell script to create few hundred pipes, then run the SQL script, then delete my few hundred pipes. right now, I have 60GB uncompressed from 6GB compressed, because I need to import into mysql.
Do not almost all operating system now have this functionality in the OS and compiler already, so that this would be an easy feature to add?
If there are security implications or other issues that I am not aware of, maybe we can just limit it to standard decompressors (bzcat, zcat); and/or require a special switch to be thrown first.
just a suggestion...
sincerely,
/iaw
How to repeat:
feature request
