Re: Load Data Infile - Ken Colburn - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlRe: Load Data Infile

From	Sent On	Attachments
Ken Colburn	16 May 2003 19:57
Ware Adams	16 May 2003 21:06
Ken Colburn	17 May 2003 05:33

Subject:	Re: Load Data Infile
From:	Ken Colburn (kcol...@comcast.net)
Date:	05/17/2003 05:33:26 AM
List:	com.mysql.lists.mysql

I'm using Win98. After my posting, I was able to load an existing *.csv table (converted from Excel) by dropping the word "local", i.e. LOAD DATA INFILE "name.csv" INTO TABLE name - using version 3.23.56 However I haven't yet made the table display correctly (lots of vertical lines - again, I'm very new at this) nor to stop the scroll to the bottom (a command I once knew in DOS).

***** On Sat, 17 May 2003 00:06:29 -0400, Ware Adams <rwal...@washdcmail.com> wrote:

Are you using Win2K? We've had this problem on Windows but not OS X. Despite what the manual says we were unable to get it to work even setting the client flag to allow load data local.

For now our Win users SSH into a Mac OS X machine and run mysql from there where the load data local works. I realize that isn't a solution for 98% of the world.

I have hope it will be fixed soon based on this from the list not too long ago:

I begin to use Mysql 4.0 and I try the tutorial. But when I use LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet; I receive the following message : ERROR 1148: The used command is not allowed with this MySQL version. The 4.0.12 services is running on W2k machines.

In the Windows binaries, the use of LOCAL is disabled by default. The manual isn't correct about that issue. It states you can enable LOCAL by starting the client with --local-infile=1, but that doesn't work.

Miguel had promised to make sure the Windows binaries will be compiled with --enable-local-infile (which would make the above option work), but hasn't done so, that's why I'm sending Cc: to him. Miguel?!

Let's hope the issue will be fixed in MySQL 4.0.13 which will be released within the next few days.

Regards,

-- Stefan Hinz <hi...@iConnect.de> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3

I have tried to Load Data Infile first with 4.0.12 and then with 3.23.56. Both times I received the error message "Error 1148: The used command is not allowed with this mysql version" I'm a very new mysql user and this command - loading an existing table - seems like a basic and very common use for the program. If relevant - I saved an Excel file as a *.csv in the mysql/data/samp_db file and used the command mysql>LOAD DATA LOCAL INFILE "filename.csv" INTO TABLE tablename. Any advice?