Hi!
On Aug 01, Dan Muey wrote:
>
> > Dear Ladies and Sirs,
> >
> > can anyone give me a hint please, if it is possible toimport
> > data data from a zipped File, without unzipping it before.
> > I'm using MySQL 3.23 on a LINUX System. I guess it is
> > possible using a 'named pipe' and 'funzip' , but I don't lnow how.
Manual:
`LOAD DATA INFILE' Syntax
...
If you need `LOAD DATA' to read from a pipe, you can use the following
trick:
mkfifo /mysql/db/x/x
chmod 666 /mysql/db/x/x
cat < /dev/tcp/10.1.1.12/4711 > /mysql/db/x/x
mysql -e "LOAD DATA INFILE 'x' INTO TABLE x" x
...
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
