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
mysql -e "LOAD DATA INFILE 'x' INTO TABLE x" x
I have many text files a day that get loaded into the db at night and was looking at
making something more real time, as these text files are created every 20 minutes.
Im using a perl script to run insert statements on these text files but it takes a
long time. The text files have around 1400000 lines every twenty minutes so you can
imagine the tables get large quick.
I thought I could wrap this LOAD DATA option in my perl script which could speed
things up... Any help is great....
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
