[freeBSD / MySQL] mkfifo et MySQL

Article View: fr.comp.os.bsd

Article #53

#53

From: patpro
Date: Sun, 15 Jun 2003 15:27

28 lines
2004 bytes

Bonjour,                             (fu2 fr.comp.os.bsd)

J'ai besoin de fournir des donn�es a un MySQLd (4.0.13) sur FreeBSD 
(4.8) via un pipe.
Le manuel MySQL mentionne : 

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 > /nt/mysql/db/x/x
mysql -e "LOAD DATA INFILE 'x' INTO TABLE x" x 

je m'interroge sur la syntaxe de la 3eme ligne. D'ou est senc� sortir de 
/dev/tcp/10.1.1.12/4711 ?
Je n'ai pas de /dev/tcp, et d'ou sort ce "/nt/" ? une erreur ?

Quelqu'un peut il m'�clair� aussi sur la suite, puisque mes datas vont 
sortir d'un pipe, vers quoi dois je les "piper" ?
Dois-je r�p�ter la s�quence : 
   cat < /dev/tcp/10.1.1.12/4711 > /nt/mysql/db/x/x
   mysql -e "LOAD DATA INFILE 'x' INTO TABLE x" x 
a chaque reboot de la machine ?

cordialement,

patpro, circonspect.

Technical Details

Message-ID: <patpro-FB3DE2.17272815062003@biggoron.nerim.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!kibo.news.demon.net!demon!aotearoa.belnet.be!news.belnet.be!nerim.net!newsspool.nerim.net!patpro

Show Full Headers

Complete Article Headers

X-Google-Language: FRENCH,ASCII
X-Google-Thread: ffbfc,e59368a311513400,start
X-Google-Attributes: gidffbfc,public
X-Google-Thread: 115e02,e59368a311513400,start
X-Google-Attributes: gid115e02,public
X-Google-ArrivalTime: 2003-06-15 08:27:29 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!kibo.news.demon.net!demon!aotearoa.belnet.be!news.belnet.be!nerim.net!newsspool.nerim.net!patpro
From: patpro <patpro@elena.patpro.net>
Newsgroups: fr.comp.os.bsd,fr.comp.applications.sgbd
Subject: [freeBSD / MySQL] mkfifo et MySQL
Followup-To: fr.comp.os.bsd
Date: Sun, 15 Jun 2003 17:27:28 +0200
Organization: patpro.net
Lines: 28
Message-ID: <patpro-FB3DE2.17272815062003@biggoron.nerim.net>
NNTP-Posting-Host: boleskine.patpro.net
X-Trace: biggoron.nerim.net 1055690848 12426 62.4.20.155 (15 Jun 2003 15:27:28 GMT)
X-Complaints-To: abuse@nerim.net
NNTP-Posting-Date: Sun, 15 Jun 2003 15:27:28 +0000 (UTC)
User-Agent: MT-NewsWatcher/3.2 (PPC Mac OS X)