Re: load data in file with pipe

2004-08-02 Thread Egor Egorov
rmck <[EMAIL PROTECTED]> wrote: > I thought I could wrap this LOAD DATA option in my perl script which could > speed things up... Any help is great You can consider using bulk insert. See http://dev.mysql.com/doc/mysql/en/INSERT.html and note that you can insert more than a single row at

load data in file with pipe

2004-07-30 Thread rmck
hello, I was tring to understand the steps to read from pipe and load using LOAD DATA INFILE? I dont understand the "x's" or the cat of tcp, can someone shed some light on this for me?? mkfifo /mysql/db/x/x chmod 666 /mysql/db/x/x cat < /dev/tcp/10.1.1.12/4711 > /mysql/db/x/x mysq