RE: LOAD DATA command not working - Mignon Hunter - com.mysql.lists.win32

4 messages in com.mysql.lists.win32RE: LOAD DATA command not working

From	Sent On	Attachments
Keno	02 Jul 2002 21:01
Mignon Hunter	03 Jul 2002 07:40
Keno	03 Jul 2002 17:17
Mignon Hunter	03 Jul 2002 18:10

Subject:	RE: LOAD DATA command not working
From:	Mignon Hunter (mhun...@houston.rr.com)
Date:	07/03/2002 07:40:10 AM
List:	com.mysql.lists.win32

I have 98 but had the same error. If you are trying:

mysql> LOAD DATA LOCAL INFILE "data.txt" INTO TABLE tablename;

Try instead:

mysql> LOAD DATA INFILE "data.txt" INTO TABLE tablename;

And I believe my txt file was in the mysql\data directory.

To run other scripts, the files have to be in the bin directory, and then type:

mysql> source file.txt;

-----Original Message----- From: Keno [mailto:ke...@coretechnologies.com] Sent: Tuesday, July 02, 2002 11:01 PM To: win...@lists.mysql.com Subject: LOAD DATA command not working

Hi all,

Just installed Mysql 3.23.51 and use the mysqld-max-nt service. Created db, tables. Now I want to load some data from an external file but I'm getting an error claiming that the load data command is not working with the version of mysql. Any ideas??