2 messages in com.mysql.lists.win32Still can't load data local infile
FromSent OnAttachments
Januski, Ken15 Nov 2002 13:31 
Januski, Ken15 Nov 2002 14:51 
Subject:Still can't load data local infile
From:Januski, Ken (kjan@phillynews.com)
Date:11/15/2002 01:31:25 PM
List:com.mysql.lists.win32

I know that this is in manual and I've seen references to the problem in google searches. Nonetheless I still can't load a local infile into a table. The following statement always produces the following error.

mysql> load data local infile "c:\Users.txt" into table users field s terminated by '\t' lines terminated by '\n'; ERROR 1148: The used command is not allowed with this MySQL version

Does anyone know of any surefire solutions, other than writing a perl script to parse the infile and put it in value by value?

Thanks for any ideas,

Ken