Re: load data local infile

[rich allen]

sound like you may want to add the following to your my.cnf file for MySQL

[mysqld]
local-infile=1

[mysql]
local-infile=1

- hcir


On Tuesday, December 31, 2002, at 06:23 PM, Terence Ng wrote:

Hi,

I have just upgraded to 3.23.54

How to input bulk data into table?

I have tried:
LOAD DATA LOCAL INFILE "lcopen1.txt" INTO TABLE
lcopen;

but it shows:
ERROR 1148: The used command is not allowed with this
MySQL version

How come?  What method can I use to input bulk data?

---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php